Reading Long Column
How do I perform string functions on the datatype LONG?
Ex. All_triggers table have column Trigger_body with datatype long. How can I get the contents of the column?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 12, 2004 11:29 PM
UPDATED:
May 13, 2004 8:29 AM
Answer Wiki:
Proceed as follows:
SQL> SET LONG 100000
SQL> select trigger_body from dba_triggers where trigger_name = 'NAME';
Here NAME stands for the trigger that you want to display. You can set LONG to any higher value if your trigger code is very long.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
