随笔分类 - SQL
摘要：DROP TABLE TEST_SPLIT PURGE; CREATE TABLE TEST_SPLIT(DATA_ID NUMBER(10), NAME VARCHAR2(100)); INSERT INTO TEST_SPLIT VALUES(1,'语文'); INSERT INTO TEST_
阅读全文
摘要：CREATE TABLE AGGTEST(NAME VARCHAR2(10),TYP VARCHAR2(10)); SELECT T.* FROM AGGTEST T; NAME TYP alley GCGC jacky GCGC pr ICGC candy GCGC dc ICGC alley G
阅读全文
摘要：--BRD:根据渠道安排随机分配置靓号 -- Create table create table T_LUCKY_ITEM ( BILL_ID VARCHAR2(20), BILL_LEVEL VARCHAR2(10), ORG_ID VARCHAR2(20), FREE_01 VARCHAR2(1
阅读全文
摘要：select last_day(add_months(date'2019-07-01',rownum-1)) busi_dt from dual connect by rownum<=months_between(date'2020-05-31',date'2019-07-01')+1 order
阅读全文
摘要：PROCEDURE PROC_GET_MAPPING_DQL(IN_USER VARCHAR2,IN_TEST1_TAB VARCHAR2,IN_TEST2_TAB VARCHAR2,IN_BUSI_DT DATE) IS V_IN_TEST2_TAB VARCHAR2(32):=UPPER(IN_
阅读全文
摘要：SELECT * FROM V$RESERVERD_WORDS; SYS_XQPOLYCELFAILEDGUARANTEEDGLOBALINFORMATIONALSEQUENCEDTIMESINCREMENTLOG_READ_ONLY_VIOLATIONSPENDINGEXPLOSIONDATANO
阅读全文
摘要：select a.table_name,c.comments,a.column_name,b.comments, decode(a.data_type,'VARCHAR2',a.data_type||'('||a.data_length||')','CHAR',a.data_type||'('||a
阅读全文
摘要：V_BEGIN_DT_M DATE; --按月开始日期 V_BEGIN_DT_Q DATE; --按季开始日期 V_BEGIN_DT_H DATE; --按半年开始日期 V_BEGIN_DT_Y DATE; --按年开始日期 V_END_DT_M DATE; --按月结束日期 V_END_DT_Q DATE; -...
阅读全文
摘要：select connect_by_root t.bank_org_code hq_bank_org_cd, connect_by_root t.branch_cd hq_branch_cd, t.branch_cd, t.busi_dt, t.org_type_cd, t.org_type_nam
阅读全文
摘要：PROCEDURE PROC_IF_ZIP_test_orig(IN_PARAM IN OUT PROC_PARAM_TYPE) IS V_MIN_ETL_DATE_1 DATE; --拉链目标表中最小ETL_DATE_1 V_MAX_ETL_DATE_1 DATE; --拉链目标表中最大ETL_DATE_1 TYPE V_CURSOR_TYPE I...
阅读全文
摘要：DECLARE V_IMPORT_DATE DATE; V_BUSI_DATE DATE; OUT_RET NUMBER; -- 0-成功, 其他失败 OUT_RET_MSG VARCHAR2(1000); PARAM PROC_PARAM_TYPE; V_MONTH_BEGIN DATE; V_M
阅读全文
摘要：SELECT SYSDATE CURRENT_DT, TRUNC(SYSDATE,'MM') MONTH_BEGIN, ADD_MONTHS(TRUNC(SYSDATE,'MM'),1)-1 MONTH_END FROM DUAL;
阅读全文
摘要：CREATE OR REPLACE TYPE PROC_WF_PARAM_TYPE AS OBJECT (/******************************************************** PARAMS OF PROC FOR WorkFlow************
阅读全文
摘要：PROCEDURE PROC_START_WF_JOB(IN_WF_PARAM IN OUT PROC_WF_PARAM_TYPE) AS V_RUNCNT NUMBER(8); V_PROGRAMNAME VARCHAR2(30); V_JOBNAME VARCHAR2(30); V_PROCNA
阅读全文
摘要：TABLE1 100 ROWS TABLE2 1000 ROWS TABLE1 LEFT JOIN TABLE2 RESULT: MIN ROWS= 100 MAX ROWS=100*1000 (TABLE1的每行记录都匹配TABLE2的1000行数据,类似主表和明细表)
阅读全文
