Interested to Buy Any Domain ? << Click Here >> for more details...
I want to know last five transactions or records from emp
table, from now?
- 11 Answers
- 21304 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 do I know if I have sql express or standard?
How do I start pl sql?
What is the importance of sqlcode and sqlerrm?
What are the two virtual tables available at the time of database trigger execution?
What do we need to check in database testing?
what are all the common sql function? : Sql dba
What is difference between table and view?
What is the difference between left and left outer join?
What is a crud api?
What is break?
What are the advantages of sql?
How do I create a sql database?
What is union?
Can a table contain multiple foreign key’s?
What is rank () in sql?
