CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: SQL*PLUS

  1. January 7th, 2002, 04:04 PM #1
    Jenny71223
    Jenny71223 is offline Junior Member
    Join Date
    Nov 2001
    Posts
    2

    SQL*PLUS

    I have a question about Oracle SQL*PLUS. I know that "SELECT * FROM TAB" can display all the table names and "SELECT * FROM SEQ" can display all the sequences. The question is, if I want to display all the triggers, what command do I use?
    I appreciate if any guru can help.

    Reply With Quote Reply With Quote
  2. January 10th, 2002, 10:22 AM #2
    Kishore A R
    Kishore A R is offline Junior Member
    Join Date
    Jul 2001
    Location
    Trivandrum, Kerala, India
    Posts
    21

    Re: SQL*PLUS


    This command will give you the trigger names

    select trigger_name from user_triggers

    All the best.

    Kishore.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured