Oracel 语句摘要

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'