#1 06 Apr 2008 18:39

zucker
Member
Registered: 06 Apr 2008
Posts: 1

Create Table for Oracle

sad   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).

Cheers,
Ron

Last edited by zucker (06 Apr 2008 18:42)

Offline

#2 06 Apr 2008 19:38

Simon Sheppard
Super Administrator
Registered: 27 Aug 2005
Posts: 902
Website

Re: Create Table for Oracle

Oops -  god knows how I managed to miss something that basic, but I've fixed those two errors now big_smile

Thanks for letting me know

Offline

Board footer

Powered by FluxBB