-1

i am trying to select the last row inserted in the employee table please any one to help me how can i get it below is the code i did

SELECT * from employee SCOPE_IDENTITY();

Michael Jazziry
  • 1
  • 2
  • I had to Google `scope_identity()`. It seems this is from Microsoft SQL Server. In Oracle SQL you will need to specify explicitly which column you want to use for ordering. (By the way, PL/SQL is the programming language, SQL is the query language, so the question should be tagged `oracle` `sql`, and not `plsql`.) – William Robertson May 29 '22 at 08:43
  • Does this answer your question? [How to get the last row of an Oracle table](https://stackoverflow.com/questions/12378424/how-to-get-the-last-row-of-an-oracle-table) – William Robertson May 29 '22 at 08:47

0 Answers0