随笔分类 - orcale
摘要：LAG(PUBLISHDATE, 1) OVER ( PARTITION BY b.FSYMBOL ORDER BY PUBLISHDATE) AS begin_date LEAD(PUBLISHDATE, 1) OVER ( PARTITION BY b.FSYMBOL ORDER BY PUBL
阅读全文
摘要：orcale 截取点后边的 SELECT SUBSTR(column_name, INSTR(column_name, '.') + 1) AS extracted_part FROM table_name; orcale 截取点前边的 SELECT SUBSTR(column_name, 0, I
阅读全文
摘要：dbms_lob.substr(content)
阅读全文
摘要：INSTR(string, search_string , start_position , nth_appearance) 其中： string是要查找的字符串。 search_string是要查找的字符或字符串。 start_position是开始查找的位置，默认为1。 nth_appearan
阅读全文
摘要：排序： SELECT LISTAGG(column_name, ',') WITHIN GROUP (ORDER BY column_name) AS concatenated_string FROM your_table; 不排序： wmsys.wm_concat('{'||sceneName||
阅读全文
摘要：SELECT * FROM ORGANIZE -- START WITH PARENT_ID = 28001-- CONNECT BY PRIOR PARENT_ID = TID 父级： SELECT * FROM ORGANIZE START WITH TID = 28001CONNECT BY
阅读全文
摘要：truncate table 表名 快速删除create table 新表 as select * from 需要备份的表INSERT INTO 需要加数据表 (SELECT * FROM 表);
阅读全文
摘要：1 UPDATE WATCHER_TASK a 2 SET a.LAST_MODIFIER_ID = ( 3 SELECT 4 b.USER_ID 5 FROM 6 task_user b 7 WHERE 8 a.TASK_ID = b.TASK_ID 9 AND b.TASK_TYPE = 3 1
阅读全文
摘要：1 insert all 2 into user (name,sex,score) values ('小明','男',80) 3 into user (name,sex,score) values ('小明','男',80) 4 into user (name,sex,score) values (
阅读全文
摘要：string转date TO_DATE('2021-01-01', 'YYYY-MM-DD') date转string TO_CHAR(SYSDATE, 'YYYYMMDD') TO_CHAR(TRUNC(SYSDATE) - 1, 'YYYYMMDD') -- 上一天
阅读全文
摘要：1 SELECT 2 to_char( START_TIME, 'YYYY-MM-DD HH24:MI:SS' ) 3 FROM 4 TASK_LOG
阅读全文
摘要：order by update desc nulls last
阅读全文
