Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007
    Posts
    64

    Thumbs down Unanswered: Clarification on RETURNING Clause usage

    Hi ,

    I am trying to get an equivalent for SQL Server's OUTPUT clause in Oracle .
    I believe RETURNING Clause will best suits for it .

    By using RETURNING Clause ,Is it possible to return the inserted values to a database table.
    Please suggest me hot to use RETURNING clause for returning values to a Table

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Yes

    UPDATE employees SET salary = salary * 1.1
    WHERE employee_id = 12345
    RETURNING last_name, salary INTO x_lname,x_sal;
    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
  •