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 LONG column with like in dba_triggers

Sid_ Z.Mar 6 2024

Hi All,

Oracle version - 19c

How do we get the trigger name where we have to find a string in the trigger body, as this is LONG datatype column so we are getting the ORA-00932: inconsistent datatypes: expected CHAR got LONG error.

select * from dba_triggers where trigger_body like '%CAL%';

Is there any other alternative to find out the list of triggers where I have a CAL to be written in the trigger body.

Regards,

Sid

This post has been answered by Sid_ Z. on Mar 7 2024

Jump to Answer

Added on Mar 6 2024

3 comments

922 views