prompt =========================================
prompt
prompt INSERT NEW STUDENT
prompt
prompt =========================================

prompt Please provide the following information:

accept stuid NUMBER  prompt "ID :"
accept fname prompt "First Name:"
accept lname prompt "Last Name:"

INSERT INTO students(studentid, firstname, lastname) 
VALUES ('&stuid', '&fname', '&lname');