in table there r so many rows write a query which two rows r
updated last two day befor?
Answers were Sorted based on User's Feedback
Answer / srinivas
select * from <table name>
order by last_updated_date
|Is This Answer Correct ?||29 Yes||6 No|
Answer / 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|
Answer / narenkumar reddy
select column_name from table_name
|Is This Answer Correct ?||1 Yes||2 No|
declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?
What is not null in sql?
Can we use loop in sql?
In what condition is it good to disable a trigger?
Why left join is used in sql?
How can analyze query after generating explain plan ?
How to call DDL statements from pl/sql?
How is sql used in oracle?
What is the difference between subquery and correlated query?
Is primary key an index?
How to use distinct and count in sql query? Explain
Which are sql * plus commands?