in table there r so many rows write a query which two rows r
updated last two day befor?
Answer Posted / ashok kumar lenka
We can solve this by the help of Trigger.
The trigger is for update.which store the update time of the
record of the table. So my query is like this
>select * from emp where to_char(update_column,'dd')=2;
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
Why stored procedure is better than query?
Explain what is dbms?
Why do we use joins?
Explain what is rdbms?
What is bind reference and how can it be created?
How to run pl/sql statements in sql*plus?
What is pl/sql table? Why it is used?
what are all different types of collation sensitivity? : Sql dba
What is online transaction processing (oltp)?
What is a composite primary key?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is the most common sql injection tool?
what is a relationship and what are they? : Sql dba
How can get second highest salary in sql?