全部博文
-
编辑 删除
Oracle 行列转换 经典
Oracle 行列转换 经典
-
编辑 删除
oracle中行数据转为列数据
例如：将"oracle"转换为oracle select substr('oracle', rownum, 1) str from dual connect by rownum <= length('oracle');同时，如果是反过来呢？列变行呢？
-
编辑 删除
常用的一些sql
--查询表锁select S.MACHINE,S.PROGRAM,O.OBJECT_NAME from v$locked_object L,dba_objects O,v$session S where L.OBJECT_ID=O.Object_Id and O.Object_Type='TABLE' and L.SESSION_ID=S.SID;--创建序列DROP SEQUENCE PMS_CODE;CREATE SEQUENCE PMS_CODE INCREMENT BY 1START WITH 40000000MAXVALUE 999999999999NOCYCLENOCACHE;select PMS_CODE.NEXTVAL from dual;select LPAD(PMS_CODE.CURRVAL,12,'0') from dual;select LPAD(PMS_CODE.NEXTVAL,12,'0') from dual;--查询归档日志alter session set nls_timestamp_format='yyyy-mm-dd h
