I want to know last five transactions or records from emp
table, from now?

Answer Posted / vikram

select * from emp where rowid >( select count(*)-n from emp)

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which data dictionary views have the information on the triggers that are available in the database?

941


What is sql scripting?

753


how to enter binary numbers in sql statements? : Sql dba

706


How can you get sql*loader to commit only at the end of the load file? : aql loader

745


How to get list of all tables from a database?

842






What is Materialized View? In What Scenario we Use Materialized View?

8938


Can we rollback truncate?

719


What is difference between hql and native sql?

777


What is trigger and how to use it in sql?

723


What are the basic sql commands?

746


difference between anonymous blocks and sub-programs.

818


What is the maximum number of columns in sql table?

778


What are pl/sql packages?

763


What are the most important characteristics of pl/sql?

782


How can you load multi line records? : aql loader

802