Total Pageviews

Saturday, March 9, 2013


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

No comments:

Post a Comment