Get ID of last inserted record in oracle db

by

Use the PL/SQL RETURNING clause:

insert into mytable (...) values (...)
returning id into v_id;

More Related Contents:

  1. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  2. How are dates stored in Oracle?
  3. How do I escape a reserved word in Oracle?
  4. How to put more than 1000 values into an Oracle IN clause [duplicate]
  5. ORA-30926: unable to get a stable set of rows in the source tables
  6. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  7. Fetch Oracle table type from stored procedure using JDBC
  8. TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
  9. “Safe” TO_NUMBER()
  10. When or Why to use a “SET DEFINE OFF” in Oracle Database
  11. error: ORA-65096: invalid common user or role name in oracle
  12. Oracle insert if not exists statement
  13. Error : ORA-01704: string literal too long
  14. Oracle client ORA-12541: TNS:no listener [closed]
  15. Does Oracle have an equivalent of SQL Server’s table variables?
  16. Create an Excel Spreadsheet from a Oracle Database
  17. How do I turn off Oracle password expiration?
  18. ORACLE IIF Statement
  19. Table-Valued Functions in ORACLE 11g ? ( parameterized views )
  20. Oracle date difference to get number of years
  21. How to increase performance for bulk INSERTs to ODBC linked tables in Access?
  22. Oracle Age calculation from Date of birth and Today
  23. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  24. Oracle: how to add minutes to a timestamp?
  25. How to drop multiple interval partitions based on date?
  26. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  27. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  28. How to Register Pluggable Database(PDB) with new created LISTENER
  29. Grant Select on all Tables Owned By Specific User
  30. ORA-12704: character set mismatch

Leave a Comment