Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    69

    Unanswered: Equivalent for inserted table

    Question on trigger conversion.

    I have something like

    "select count(*) from inserted" in trigger code written in SQL Server.

    What is the equivalent of "inserted" table in Oracle

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    There is no direct equivalent. Row-level triggers have :OLD and :NEW to reference row values before and after the change.

    If you describe your requirement (without reference to SQL Server techniques) we may be able to suggest the Oracle solution.

Posting Permissions

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