create new table

Syntax 1

creating new table
----------------------------
CREATE TABLE table_name (
field1 datatype,
field2 datatype,
...);

example :
CREATE TABLE customer (
id number,
name varchar2(50));


Syntax 2
creating table from other existing table,
the structure of new table copied from source table.
----------------------------
CREATE TABLE table_name as select * from existing_table;

example :
CREATE TABLE customer2 as select * from customer;