Friday, September 21, 2012

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%';