-- 根据自有字段进行分区
create table T_YD_DZS
(
  TID        VARCHAR2(32),
  USER_PHONE VARCHAR2(32),
  CONTENT1   VARCHAR2(64),
  CONTENT2   VARCHAR2(64),
  CONTENT3   VARCHAR2(64),  
  STAT_TIME  DATE,
  LAST2      VARCHAR2(4) default SUBSTR('USER_PHONE',-1,1)
)
partition by list (LAST2)
(
  partition P0 values ('0'),
  partition P1 values ('1'),
  partition P2 values ('2'),
  partition P3 values ('3'),
  partition P4 values ('4'),
  partition P5 values ('5'),
  partition P6 values ('6'),
  partition P7 values ('7'),
  partition P8 values ('8'),
  partition P9 values ('9')
);
comment on table T_YD_DZS
  is '阅读类电子书';
comment on column T_YD_DZS.TID
  is 'ID 自动增长';
comment on column T_YD_DZS.USER_PHONE
  is '手机号';
comment on column T_YD_DZS.CONTENT1
  is '内容一';
comment on column T_YD_DZS.CONTENT2
  is '内容二';
comment on column T_YD_DZS.CONTENT3
  is '内容三';


其实SYS_CONNECT_BY_PATH这个函数是oracle9i才新提出来的！
它一定要和connect by子句合用！
第一个参数是形成树形式的字段，第二个参数是父级和其子级分隔显示用的分隔符！


START WITH 代表你要开始遍历的的节点！

CONNECT BY PRIOR 是标示父子关系的对应！

http://blog.itpub.net/25801738  我以前整的，后来没坚持下来

http://blog.sina.com.cn/u/1776404243

tools-首选项-编辑器-autoreplace
ro = row_number() over(partition by order by) as rn
ss = select * from
s = select
f = from
it = insert into
df = delete from
scc = select * from all_col_comments
stc = select * from all_tab_comments
so = select * from all_objects