Dear Experts,
Please help to get the data from below query.
CREATE TABLE ERR_LOG
(
TRAN_ID VARCHAR2(20),
ERR_DESC VARCHAR2(2000),
ERR_DATE DATE
);
INSERT INTO ERR_LOG VALUES (1,'Error while Inserting DAILY_TABLE 1 at Index 1 ERR MSG ORA-01861: literal does not match format string',SYSDATE);
INSERT INTO ERR_LOG VALUES (2,'Error while Inserting DAILY_TABLE 2 at Index 2 ERR MSG ORA-0001: ORA-00001: unique constraint (.) violated',SYSDATE);
INSERT INTO ERR_LOG VALUES (3,'Error while Inserting DAILY_TABLE 3 at Index 3 ERR MSG ORA-0001: ORA-00001: unique constraint (.) violated',SYSDATE);
SELECT tran_id FROM ERR_LOG WHERE (ERR_DESC NOT LIKE '%ORA-00001%')
AND (ERR_DESC NOT LIKE '%DAILY_TABLE%')
AND TRUNC(ERR_DATE)=TRUNC(SYSDATE);
Expected result
1
Please help