1.查看oracle版本信息
select * from product_component_version
2.查询索引
select * from user_indexes
3.创建文本索引
create index tvideo_textindex_catid on tvideo(catid) indextype is ctxsys.context
4. 使用文本索引查询文本内容
select * from tvideo where contains (title,'ceshi text')>0
5.删除列
ALTER TABLE tvideo DROP COLUMN remark5;
6.增加列
ALTER TABLE emp01 ADD eno NUMBER(4);
7.增加注释
COMMENT ON TABLE employee IS '存放雇员信息';
8.修改表名
RENAME emp01 TO employee;
9.修改列名
ALTER TABLE emp01 RENAME COLUMN eno TO empno;
10.修改列定义
ALTER TABLE emp01 MODIFY job VARCHAR2(15) DEFAULT 'CLERK'