oracle»ù´¡ÈëÃŽ̲Ä

 
½¨±í
create table <table_name>(
column_name1 column_type [not null] [check (expression)]
    [default value] [primary key][references <table_name>(column_name)],
column_name2 column_type [not null] [check (expression)]
    [default value] [primary key][references <table_name>(column_name)]
....
[constraint primary_name
   primary key(column_name1,column_name2...)
]
[unique(<column_name1,column_name2...>)]
                        );
create table <table_name>
as
     select * from <other_table_name> where <condition>
---------------------------------------------------------------------------------------
¸Ä±í½á¹¹
1 alter table <table_name> add(column_name column_type);
2 alter table <table_name> modify(column_naem column_type);
---------------------------------------------------------------------------------------
ɾ±í
drop table <table_name>;
truncate table <table_name>;
---------------------------------------------------------------------------------------
±íµÄÖØÃüÃû
rename <table_name1> to <table_name2>;
---------------------------------------------------------------------------------------
²åÈëÊý¾Ý
1 insert into <table_name> (column_name1, column_name2, ....)
    values   (column_value1, column_value2,.... );
2 insert into <table_name>
    values   (column_value1, column_value2,.... );   
3 insert into <table_name> (column_name1, column_name2, ....)
      select expression1,expression2, ....
      from   <table_name>
      [where <condition_expression>];
---------------------------------------------------------------------------------------
±íµ