Hi All,
we have a requirement where we need to fetch data from one of the table on daily basis and it will run at 5 am daily. we need to fetch data which is lesser than 9 pm(previous date).
condition should be based out on CDC_LOG_TSTP column, i have tried multiple queries but its not working for me. could you please help me get the solution of this requirement.
below is the structure of the table:
desc seods01.cola_cl_phn_nbr
Name Null Type
--------------------- -------- ------------
CL_PHN_ID NOT NULL NUMBER(18)
PRTT_CDE NOT NULL VARCHAR2(10)
CL_ID NOT NULL VARCHAR2(23)
EODS_CL_ID_CNTX_CDE NOT NULL VARCHAR2(50)
EODS_CL_ID NUMBER(38)
PHN_LBL_TXT NOT NULL VARCHAR2(30)
PHN_SUB_LBL_TXT NOT NULL VARCHAR2(60)
CTRY_CDE NOT NULL VARCHAR2(5)
NANP_NBR_PLN_AREA_CDE NOT NULL VARCHAR2(3)
NANP_CTR_OFC_EXCH_CDE NOT NULL VARCHAR2(3)
NANP_SBSC_NBR NOT NULL VARCHAR2(4)
NON_NANP_PHN_NBR_TXT NOT NULL VARCHAR2(15)
EXTN_NBR NOT NULL VARCHAR2(6)
SMS_ENBL_IND NOT NULL CHAR(1)
SMS_ENRL_STAT_CDE NOT NULL VARCHAR2(2)
VOICE_FUNC_STAT_CDE NOT NULL VARCHAR2(2)
VOICE_FUNC_INOPER_DTE NOT NULL VARCHAR2(10)
TXT_FUNC_STAT_CDE NOT NULL VARCHAR2(2)
TXT_FUNC_UDLV_DTE NOT NULL VARCHAR2(10)
PHN_PRFR_CDE NOT NULL VARCHAR2(2)
FAX_ENBL_IND NOT NULL CHAR(1)
SRC_CRTE_OPER_ID NOT NULL VARCHAR2(8)
SRC_CRTE_PGM_NME NOT NULL VARCHAR2(8)
SRC_CRTE_TSTP NOT NULL TIMESTAMP(6)
SRC_UPDT_OPER_ID NOT NULL VARCHAR2(8)
SRC_UPDT_PGM_NME NOT NULL VARCHAR2(8)
SRC_UPDT_TSTP NOT NULL TIMESTAMP(6)
CDC_LOG_TSTP NOT NULL TIMESTAMP(6)
DATA_GRP_CDE NOT NULL VARCHAR2(10)
CRTE_PGM NOT NULL VARCHAR2(50)
CRTE_TSTP NOT NULL TIMESTAMP(6)
UPDT_PGM VARCHAR2(50)
UPDT_TSTP TIMESTAMP(6)