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


Please Help Members By Posting Answers For Below Questions

Is sql considered coding?

561


How to fix oracle error ora-00942: table or view does not exist

560


Can we rename a column in the output of sql query?

536


What is pl sql quora?

635


What is sql procedures and functions?

520






Can a foreign key have a different name?

503


What is Difference Between Unique and Primary Key Constraints?

595


What is the purpose of my sql?

496


Is crud a cuss word?

537


What is %type in pl sql?

531


what is isam? : Sql dba

564


How do I create a sql database?

516


Can we use update in sql function?

568


What is input buffer in sql*plus?

629


What is package in pl sql?

568