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

What is cursor explain with example?

965

---

What is meant by cursor in sql?

972

---

Does group by remove duplicates?

1020

---

how to drop an existing index in mysql? : Sql dba

1053

---

What program will open a mdb file?

948

---

How is indexing done in search engines?

972

---

What is difference between rank () row_number () and dense_rank () in sql?

1090

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2006

---

what is a composite key ? : Sql dba

1033

---

Why are sql stored procedures used?

1043

---

Which table is left in left join?

992

---

Is pl sql still used?

961

---

how is exception handling handled in mysql? : Sql dba

1062

---

What are all ddl commands?

1065

---

What is difference between pls_integer and integer?

939

---