Interested to Buy Any Domain ? << Click Here >> for more details...
in table there r so many rows write a query which two rows r
updated last two day befor?
- 3 Answers
- 10344 Views
- Exilant, I also Faced
- E-Mail Answers
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
Explain the difference between triggers and constraints?
What are operators available in sql?
Can there be more than one function with a similar name in a pl/sql block?
Which table is left in join?
What is execution plan in sql?
What are the different ways to optimize a sql query?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What does select count (*) mean in sql?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What is difference between ms sql and mysql?
how to use regular expression in pattern match conditions? : Sql dba
What is the usage of nvl function?
Can a table have no primary key?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
