I want to know last five transactions or records from emp
table, from now?
- 11 Answers
- 19170 Views
- Wells Fargo, I also Faced
- E-Mail Answers
Answer Posted / eshwer
create trigger on emp table with last_transaction with datatype as date or timestamp,
now you have to use dml commands on emp table, when ever u done any modifications on the table these will be inserted in
last_transaction with sysdate with last modification time,
based on time we can find out the last transactions
based on
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How insert into statements in sql?
Which table is left in join?
Is ms sql traffic encrypted?
What is the difference between inner join and left join?
Determine if oracle date is on a weekend?
What is rank function in sql?
What is mutating sql table?
How many scalar data types are supported in pl/sql?
How do I view a table in sql?
How many types of sql are there?
How to use boolean type in select statement?
What is cross join sql?
What are all the ddl commands?
Is oracle sql free?
Explain the order of sql statement execution?
