1、创建表
create table stu_info (id int,stu_name varcahr2(10));
--复制表结构
create table stu_info as select * from emp where 1=2;
--复制全部数据
create table stu_info as select * from emp where 1=2;
2、插入数据
insert into stu_info(1,'王明');
3、更新数据
update stu_info set id=0 where stu_name='王明';
4、删除行数据
delete from stu_info where id='name';
删除列
alter table stu_info drop column name;
清空数据
truncate table stu_info;
5、修改表名
alter table stu_info rename to stu_name;
修改列名
alter table stu_info rename column id to id_new;
6、ALTER TABLE 表名 ADD CONSTRAINT 约束名 约束内容。
ALTER TABLE 表名 ADD CONSTRAINT 约束名 PRIMARY KEY(列名1[,列名2...])
7、给表添加注释
COMMENT ON TABLE 表名 IS 注释;
--对列添加注释
COMMENT ON COLUMN 表名.列名 IS '注释信息';
8、创建索引
CREATE [UNIQUE] INDEX 索引名 ON 表名(列名1[,列名2…])
9、创建视图
CREATE OR REPLACE [{FORCE|NOFORCE}] VIEW 视图名
10、创建触发器(后面详细总结下)
CREATE [OR REPLACE] TRIGGER trigger_name
{BEFORE | AFTER }
{INSERT | DELETE | UPDATE [OF column [, column …]]}
[OR {INSERT | DELETE | UPDATE [OF column [, column …]]}...]
ON [schema.]table_name | [schema.]view_name
[REFERENCING {OLD [AS] old | NEW [AS] new| PARENT as parent}]
[FOR EACH ROW ]
[WHEN condition]
PL/SQL_BLOCK | CALL procedure_name;