Search notes:

ORA-00906: missing left parenthesis

The ORA-00906: missing left paranthesis error is thrown, for example, when trying to create a table with a varchar2 column whose maximum length is not specified (compare with the PL/SQL error PLS-00215: String length constraints must be in range (1 .. 32767)):
create table tq84_x (vc varchar2);

See also

Other Oracle error messages such as ORA-00907: missing right parenthesis

Index