DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Trigger body

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hello : I have to modify a trigger and I want to pull that from the source. I have always pulle dup procedures from user_source and have modified it and saved it and compiled. Similarly how do I do it with triggers? If I use user_triggers what should the value of long be ? so I can see the entire text.
    Thanks, ST
    ~

  2. #2
    Join Date
    Apr 2001
    Location
    UK
    Posts
    137
    Use trigger_body from sys.dba_triggers. It's a long column, so you may have to do "set long xxxxx" in sql*plus to see all of it.

  3. #3
    Join Date
    Oct 2000
    Posts
    76
    Why don't you use something like TOAD? I think you could done load a basic version for free.
    J.T.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width