select * from emp order by effective_start

In a table their 20 records.I had update 6 records???How
can see and retrieve particular 6 records.i.e.,Latest
updated.

Question Posted / ratnakar

Answer Posted / ratnakar

select * from emp order by effective_start_date;

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How can we import the data into a database using sql * loader?

1242

What are the different components of soa suite?

1265

What is oracle soa suite?

1299

testing tools?

2301

Can we create tables in apps schema?

1184

Do you know what are user profiles in apps. Any examples you can give?

1140

How can a process be deployed in soa?

1336

What do you understand by concurrent programs?

1145

What is oracle soa suite and what are its different components?

1281

can we use look up type instead of a pofile option?or valueset?is it possible how?

2264

How can you achieve loose coupling in soa framework?

1275

what are the prerequisites for costing transactions?

3187

how to print multi lay outs,muti currency,muti language in xml publisher

12394

In hierarchical structure of a database? we have write query from where we should start?

2304

what is the differences between internal requisition and internal sales order?

2711