>
> Ari ,
>
> Thanks for your help on database startup on reboot of machine ...
>
> Another question I have,
>
> SQL> desc user_triggers;
> Name Null? Type
> ------------------------------- -------- ----
> TRIGGER_NAME NOT NULL VARCHAR2(30)
> TRIGGER_TYPE VARCHAR2(16)
> TRIGGERING_EVENT VARCHAR2(26)
> TABLE_OWNER NOT NULL VARCHAR2(30)
> TABLE_NAME NOT NULL VARCHAR2(30)
> REFERENCING_NAMES VARCHAR2(87)
> WHEN_CLAUSE VARCHAR2(2000)
> STATUS VARCHAR2(8)
> DESCRIPTION VARCHAR2(2000)
> TRIGGER_BODY LONG
>
> here you can see that Trigger Body is long, is there a way to see the
> complete content of this column for a specific trigger.
>
> I set linesize up to 400 and no luck, set wrap on still a bad try and I
> could see only the begining portion of the code ....
>
> If you have any tip please let me know...
>
> Thanks
> Bijilal
>
Yes. do "SET LONG 10000". The linesize does not matter.
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 160+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page