Is there an Oracle equivalent to SQL Server’s OUTPUT INSERTED.*?

by

Maybe I don’t understand the question, but wouldn’t this do it? (you must know what you want back)

INSERT INTO some_table (...)
VALUES (...)
RETURNING some_column_a, some_column_b, some_column_c,  ...  INTO :out_a, :out_b, :out_c, ...

@Vincent returning bulk collect into for multi-row insert works only in conjunction with forall (in another words if you insert from collection you can retrieve “results” into another)

More Related Contents:

  1. Merging two tables in SQL [closed]
  2. Is there a combination of “LIKE” and “IN” in SQL?
  3. SQL – How to store and navigate hierarchies?
  4. Can a foreign key be NULL and/or duplicate?
  5. Is it possible to output a SELECT statement from a PL/SQL block?
  6. Multiplication aggregate operator in SQL
  7. Stored Procedure with optional “WHERE” parameters
  8. Pivoting rows into columns dynamically in Oracle
  9. Using ‘case expression column’ in where clause
  10. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  11. Concatenate results from a SQL query in Oracle
  12. How to use BOOLEAN type in SELECT statement
  13. How to kill a running SELECT statement
  14. Selecting the second row of a table using rownum
  15. Update with Join query in Oracle
  16. How to count the number of occurrences of a character in an Oracle varchar value?
  17. Deferrable Constraints in SQL Server
  18. Benefits Of Using SQL Ordinal Position Notation?
  19. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  20. Unordered results in SQL
  21. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  22. update columns values with column of another table based on condition [duplicate]
  23. How do I list all the columns in a table?
  24. Oracle date “Between” Query
  25. ORA-01861: literal does not match format string
  26. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  27. Oracle Date TO_CHAR(‘Month DD, YYYY’) has extra spaces in it
  28. Query a Table’s Foreign Key relationships
  29. Backup SQL Schema Only?
  30. Connecting to Oracle Database using Sql Server Integration Services

Leave a Comment