How to get the last row of an Oracle a table

Question

I want to get the last row  which I inserted into a table in an Oracle 11g Express database   How can I do this

User · Answer

SELECT   FROM    MY TABLE WHERE     lt your filters gt  ORDER BY PRIMARY KEY DESC FETCH FIRST ROW ONLY

User · Answer

There is no such thing as the  last  row in a table  as an Oracle table has no concept of order   However  assuming that you wanted to find the last inserted primary key and that this primary key is an incrementing number  you could do something like this   select     from   select a    max pk  over    as max pk            from my table a                    where pk   max pk   If you have the date that each row was created this would become  if the column is named created   select     from   select a    max created  over    as max created            from my table a                    where created   max created   Alternatively  you can use an aggregate query  for example   select     from my table  where pk     select max pk  from my table     Here s a little SQL Fiddle to demonstrate

User · Answer

select   from table name ORDER BY primary id DESC FETCH FIRST 1 ROWS ONLY    That s the simplest one without doing sub queries

User · Answer

SELECT   FROM       SELECT   FROM table name ORDER BY sortable column DESC   WHERE ROWNUM   1

User · Answer

sql    INSERT INTO table name  field1  field2    VALUES   foo   bar            RETURNING ID INTO  mylastid    stmt   oci parse  db   sql   oci bind by name  stmt   mylastid    last id  8  SQLT INT   oci execute  stmt    echo  last inserted id is    last id      Tip  you have to use your id column name in  your id col name  below      RETURNING  your id col name  INTO  mylastid

User · Answer

The last row according to a strict total order over composite key K k1       kn    SELECT    FROM    TableX AS o WHERE   NOT EXISTS               SELECT                FROM    TableX AS i             WHERE   i k1  gt  o k1                 OR   i k1   o k1 AND i k2  gt  o k2                                      OR   i k1   o k1 AND i k2   o k2 AND i k3   o k3 AND     AND i kn  gt  o kn                Given the special case where K is simple  i e  not composite   the above is shortened to   SELECT    FROM    TableX AS o WHERE   NOT EXISTS               SELECT                FROM    TableX AS i             WHERE   i k1  gt  o k1               Note that for this query to return just one row the key must order without ties  If ties are allowed  this query will return all the rows tied with the greatest key

User · Answer

You can do it like this   SELECT   FROM  SELECT your table your field  versions starttime                FROM your table                VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE  WHERE ROWNUM   1    Or   SELECT your field ora rowscn scn to timestamp ora rowscn  from your table WHERE ROWNUM   1

[sql] How to get the last row of an Oracle a table

Examples related to sql

Examples related to oracle

Examples related to oracle11g