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
Is sql considered coding?
How to fix oracle error ora-00942: table or view does not exist
Can we rename a column in the output of sql query?
What is pl sql quora?
What is sql procedures and functions?
Can a foreign key have a different name?
What is Difference Between Unique and Primary Key Constraints?
What is the purpose of my sql?
Is crud a cuss word?
What is %type in pl sql?
what is isam? : Sql dba
How do I create a sql database?
Can we use update in sql function?
What is input buffer in sql*plus?
What is package in pl sql?