The syntax offered for create table (http://ss64.com/ora/table_c.html) is missing a pair of parenthesis. For example your syntax suggests:
create table test testname varchar2(20);
should work. It does not! The correct syntax is:
create table test (testname varchar2(20));
Also constraints must be separated by a comma.
Otherwise this is one of the best Oracle sites on the web (including Oracle's Own).
Last edited by zucker (06 Apr 2008 18:42)