Oracle基本语法：操作表结构与表数据

CREATE TABLE table_name
(
column_name datatype,...
);

在建表时复制： 
create table table_new as select column1,...|*  from table_old;
在添加数据时复制：
insert into table_new [(column1,...)] select column1,...|*  from table_old;

alter table table_name add column_name datetype;

INSERT INTO table_name(column1,column2,...) VALUES(value1,value2,...);

alter table table_name modify column_name datatype; 

alter table table_name rename column column_name to new_name;

rename table_name to new_table_name;

Update table_name 
Set column1=value1,column2=value2,...[where conditions]

alter table table_name drop cloumn column_name;

删除表中全部数据，速度比DELETE快很多 
TRUNCATE TABLE tbl_name;

删除整个表结构 
DROP TABLE tbl_name; 

delete from table_name [where condition];