Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2009
    Posts
    16

    Unanswered: How do you view all triggers created?

    Hey, i just want to see what triggers i've created but I don't know
    how. I'm using Oracle SQL Plus

    thanx

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    first thing you should do is post in the correct forum

    please contact a moderator and ask that this thread be moved
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2009
    Posts
    16

    Then how do i move this?

    I thought this was the most appropriated forum 2 post it cos my questiion
    regarded SQL, where should i post my SQL queries then? and i also don't know how to contact a moderator to shift this and i wouldn't know where 2 shift it too.

    Thanx

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    mysql is a database system very much different from the oracle database system

    they both use a version of the SQL language, but these versions are substantially different in several ways

    you should have posted in the oracle forum

    moderators for this forum, who can move the thread, are healdem and pat phelan
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    if you want the triggers in your schema.

    select trigger_name
    from user_triggers;
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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