Oracle 快捷手册

一、基本操作

1、修改数据表

alter table T add C NUMBER(1);

alter table T drop column C;

alter table T rename column C to C1;

2、为已存在表添加外键

alter table table_name add constraint fk_name FOREIGN KEY (col) REFERENCES table2_name(col);

3、添加序列
create sequence SEQ_SNS_BOOKS
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

4、添加组合索引
create index ind_book_ch on book_channel(book_id,channel_id) ;

二、查询

1、查询时间(三天前的此刻)
select sysdate-3 from dual;

2、前10条数据

select book_id from table1 where rownum<11

3、查询第3至5条数据

SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM xueci_ciku A
WHERE ROWNUM <= 5
)
WHERE RN >= 3

4、分类的所有后代分类

select id from CATEGORY start with pid=123 connect by prior id = pid