Friday 15 March 2013

sql - The string constant beginning with "')" does not have an ending string delimiter -


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