if u know updated date then following query will work select * from emp

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

10 Answers
18335 Views
HCL, TCS, I also Faced
E-Mail Answers

Answer Posted / ratnakar

if u know updated date then following query will work

select * from emp where effecive_start_date = (select
sysdate from dual);

or

select * from emp where effective_start_date = (select
to_date(dateof update,'dd-mon-yy') from dual);

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3032

What is count(*) from po_vendors(any table)?

1057

What are the benefits of using soa architecture?

1206

Explain what are the tables of auto invoice?

1112

Can we create tables in apps schema?

1103

how do you describe O2C along with tables

2745

is it possible to run the interface without using oracle apps?

1947

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

2203

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

1066

Plz anybody send me Technical specification for AP Interface

2526

q)what are the validations in sql*loader

2365

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2231

In oracle application how do you debug or trace errors?

1076

Explain oracle apps architecture.

1207

Are you familiar with internet architecture of oracle apps 11i?

1037