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
- 21348 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
What is cross join example?
What is sql resultset?
What is crud stand for?
how is exception handling handled in mysql? : Sql dba
When do we use triggers?
Can we insert delete data in view?
What packages(if any) has oracle provided for use by developers?
How insert into statements in sql?
How do you update f as m and m as f from the below table testtable?
What is a join query?
what is sql server agent? : Sql dba
What are the different sql languages?
Why do we need pl sql?
what is foreign key? : Sql dba
What is the usage of nvl function?
