oracle sql(missing left parenthesis [closed]

CREATE TABLE grad_candidates  
(student_id NUMBER(6),

last_name VARCHAR2,
first_name VARCHAR2
,
credits NUMBER
(3),
graduation_date DATE DEFAULT SYSDATE);
ORA-00906: missing left parenthesis,, Can anyone help??


Views: 28

Reply to This

Replies to This Discussion

VARCHAR2 requires a numerical bound to go with it, for example:

last_name VARCHAR2(30),

So, change your code to:



CREATE TABLE grad_candidates
(student_id NUMBER(6),
last_name VARCHAR2
(255),
first_name VARCHAR2
(255),
credits NUMBER
(3),
graduation_date DATE
DEFAULT SYSDATE);

Reply to Discussion

RSS

Oracle Jobs in US

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service