Oracle database new table

[EMW]

Is it not possible to just create a new table in an existing database with
CREATE TABLE and without copying an existing table?

I have an empty database and when my program detects the tables aren't
there, I want it to create the table.
But according to the documentation I need to use INSERT * INTO table FROM
othertable
but there is no other table.

rg,
Eric

 

[Rob Panosh]

Eric,

Use the CREATE TABLE command (see oracle documentation).

Example:
CREATE TABLE customer ( custid number(10,0) NOT NULL, firstname
varchar2(10) )

Hope this helps.

Regards,
Rob

 

[EMW]

thanks that helps a lot!

Eric,

Use the CREATE TABLE command (see oracle documentation).

Example:
CREATE TABLE customer ( custid number(10,0) NOT NULL, firstname
varchar2(10) )

Hope this helps.

Regards,
Rob