Monday, January 26, 2009

Missing Comma

INPUT:
SQL> @ezinsert.sql

OUTPUT:
SQL> spool ezinsert.lst
SQL> set echo on
SQL> set feedback on
SQL> insert into office_tbl values
2 ('303785523' 'SMITH', 'OFFICE OF THE STATE OF INDIANA, ADJUTANT
GENERAL')
3 /
('303785523' 'SMITH', 'OFFICE OF THE STATE OF INDIANA, ADJUTANT
GENERAL')
*
ERROR at line 2:
ORA-00917: missing comma
SQL> spool off
SQL>

ANALYSIS:
On line 2 a comma is missing between the Social Security number and SMITH.

No comments: