Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query With not Like

Ricky007Jul 3 2020 — edited Jul 3 2020

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

This post has been answered by Solomon Yakobson on Jul 3 2020
Jump to Answer
Comments
Post Details
Added on Jul 3 2020
5 comments
8,916 views