I at least imp. SQL is designed to input the user's input data but it shows an error near line 11: "ending" is not the end of the SQL0010N string '') "string delimiter What should I do to fix this problem ?
In-emp.sql
Prompt 'Entry for Employee Table' Prompt Accepted v_emp_id Format a5 Prompt 'Employee Id:' Accept V_emp_name Format a25p Receive 'Employee's Name:' v_address format A50 prompt: Accept 'v_tel_no format a14 prompt'. Tel: 'Accept the V-Adobe prompt' date (yyyy-mm-dd): 'v_stor_id Format A4 Accept Prompt' Store ID: Enter the employee values ('& amp; v_emp_id,' & amp; v_emp_name ',' & amp; v_address', '& amp; v_tel_no', '& v_dob', '& amp; v_stor_id'); cre-emp.sql
drop table employee; table employee (emp_id varchar (5) tap, emp_name varchar (25), address varchar (50 ), Tel_no varchar (14), dob date, stor_id v Archar (4), primary key (emp_id), foreign key (stor_id) referral stores (store_id), Hiradb check of obligation (year (dob) & lt, 1996);
one is missing '- this is better:
employee Enter in values ('& amp; v_emp_id', '& amp; v_emp_name', '& amp; v_address', '& v_tel_no', '& v_dob', '& amp; v_stor_id'); ^
No comments:
Post a Comment