天秤焕妍

oracle11g 自动创建分区年/月/日/周 –建表时创建自动分区 CREAT TABLE TABLE1 ( TABLE_ID NUMBER(8), SUB_DATE DATE, VALUE NUMBER(8) ) PARTITION BY RANGE(SUB_DATE) INTERVAL(NUMTOYMINTERVAL(1,‘MONTH’))–按月分区 ( PARTITION P1 VALU...

  在具有dba权限用户进行执行以下语句：  1.查看被锁的表： SELECT t.session_id as sid, t2.serial#, t.locked_mode, t.oracle_username, t.os_user_name, t2.machine, t2.terminal, ...

--将多行字符串拆分 with p as --构建数据临时表 (select 1 as id, 'aa,bb,cc,dd,ee' as split_string, 1 as num from dual union all select 2, 'ff,gg,hh,ii,jj,kk', 3 from dual union all select 3, 'aa,bb,...