Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    57

    Unanswered: problems using Oracle SQL * Plus

    hey folks,
    i am trying to view the body of one of my Triggers and it only shows me the first 4 lines. i do something like this:

    SQL> SELECT TRIGGER_BODY FROM DBA_TRIGGERS WHERE TRIGGER_NAME = 'STUDENT_UPDATE';

    and the result is:

    TRIGGER_BODY
    --------------------------------------------------------------------------------
    DECLARE
    SUPPCOLLEGEID INTEGER;
    DEMOGRAPHICID INTEGER;
    SUPPHSID INTEGER;
    b

    where is the rest?
    help!

    thanks all.

  2. #2
    Join Date
    Oct 2003
    Posts
    57
    never mind. i figured it out, all i had to do was this:

    set long [number of characters of type LONG to be displayed]

    sorry for the dumb question.

Posting Permissions

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