Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Unanswered: SELECT inside a trigger

    hi all,

    Can anyone let me know how efficient is using SELECT statement inside the body of trigger?

    Thanks is Advance.

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    I am not sure what you are asking for here? A trigger is internal functionality inside a database which can be used to either marge data into different tables or perform simple or complex data integrity constraints.

    If you are looking to have records returned then i would suggest you look at stored procedures or stored functions.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Tags for this 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
  •