Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    13

    Unanswered: About PL\SQL Trigger...

    Hi all, I just wondering, when we should use Trigger statement and Trigger row? Because I'm not really understand in this part.

    emm, where I can get complete free tutorial about this SQL Trigger?

    Thanks in advance.
    Correct me if I wrong.

  2. #2
    Join Date
    Mar 2004
    Location
    Venice,Italy
    Posts
    20
    the difference is when you insert more row in a time (tipically with a insert into ... select..)
    Trigger statement is tipically faster, because is called one time, trigger row are tipically more easy to write because you have to manage only a row a time.
    Trigger statement can be usefull also for checking a complex check that involve a set of row as a whole (for example chaecking the sum of a column must to be zero...)
    pay attention that not every rdbm has both: for example, MS SQL has only the trigger statement, sqlite "for each row " only...

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: About PL\SQL Trigger...

    You mention PL/SQL, so you are talking about Oracle triggers. See the free online documentation here:

    Application Developer's Guide

    Concepts

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: About PL\SQL Trigger...

    Regarding your first question:
    • Statement-level triggers fire once only per statement, and cannot refer to specific row values using :OLD and :NEW
    • Row-level triggers fire once per row affected by the statement, and can refer to specific row values using :OLD and :NEW

Posting Permissions

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