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: 29

▶ Reply to This

Replies to This Discussion

Permalink Reply by Mare Rosa on May 2, 2013 at 11:11am

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

Groups

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service