How to Query on the LONG datatype Columns
-- Create the custom table as mentioned below
CREATE TABLE XX_ALL_TRIGGERS AS SELECT TRIGGER_NAME,TO_LOB(TRIGGER_BODY) AS TRIGGER_BODY FROM ALL_TRIGGERS;
--After creating the table execute the below query
SELECT * FROM XX_ALL_TRIGGERS WHERE UPPER(TRIGGER_BODY) LIKE 'XX%TRG%';
CREATE TABLE XX_ALL_TRIGGERS AS SELECT TRIGGER_NAME,TO_LOB(TRIGGER_BODY) AS TRIGGER_BODY FROM ALL_TRIGGERS;
--After creating the table execute the below query
SELECT * FROM XX_ALL_TRIGGERS WHERE UPPER(TRIGGER_BODY) LIKE 'XX%TRG%';
No comments:
Post a Comment