Create table command using various ways | create table in oracle 10g

Different ways to create table in database
following are some information about how to create table

so please refer this information



Creating Table

Syntax:
CREATE TABLE table_name(
column1 datatype[size],
column2 datatype[size],
column3 datatype[size],

....
);

Example:
create table student(
roll_no number(3),
stud_name varchar(20),
bdate date,
marks number(3));



Insert Record:
Syntax :
insert into table_name values (value1,value2,value3,...);

Example:
insert into student values(1,'Milind','01-jan-1987',50);
insert into student values(2,'Ram','05-Aug-1988',75);
insert into student values(3,'Rahul','03-Mar-1989',89);

Creating New Table From Existing Table:
Syntax:
create table table_name
as select * from existing_table_name;

Exapmle:
create table studentnew
as select * from student;

Creating new table having specific filed but all the records from existing table.
Synatx :
create tabel table_name
as select field1,field2,... from existing_table_name;

Example:
create table studentnew1
as select roll_no,stud_name from student;

Creating new table having specific filed but all the fields from existing table.
Syntax:
create table table_name
as select * from existing_table_name
where condition;

Example:
create table studentnew2
as select * from student
where marks greater than symbol 60;