Oracle database new table

  • Thread starter Thread starter EMW
  • Start date Start date
E

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
 
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
 
thanks that helps a lot!

Rob Panosh said:
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
Click to expand...
 
Back
Top