Interested to Buy Any Domain ? << Click Here >> for more details...
In a table their 20 records.I had update 6 records???How
can see and retrieve particular 6 records.i.e.,Latest
updated.
- 10 Answers
- 18453 Views
- HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / orchid
Since the following sql
select * from aa
where rownum <= 6
order last_updated_date desc
will return random 6 rows and then the
order by 'last_updated_date desc' will only apply to
selected 6 records, so you won't get latest updated 6
records.
Please correct me if I was wrong.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is oracle soa suite?
What is a value set? List its various types.
How many schemas we have? how many you have used?
How can a process be deployed in soa?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
In oracle application how do you debug or trace errors?
In hierarchical structure of a database? we have write query from where we should start?
Are you familiar with internet architecture of oracle apps 11i?
how to print multi lay outs,muti currency,muti language in xml publisher
What do you understand by concurrent programs?
How to move the one file from one instance to another instance? And your scripts also?
Which oracle apps version you are very confident in?
What do you understand by soa and what are the benefits of using this architecture?
where to define interorganization transaction charges and what are the different options?
What is instead of trigger in where we will use?
