here is the query update emp set sal =(select min(sal) from emp) where sal

If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?

Advance Thanks

Question Posted / madhu

7 Answers
10386 Views
Puma, I also Faced
E-Mail Answers

Answer Posted / madhu

here is the query
update emp set sal =(select min(sal) from emp) where sal is null

Is This Answer Correct ?

9 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to extract sap data using informatica?

1007

What's the layout of parameter file (what does a parameter file contain?)?

2351

What is DR strategy for Informatica project?

1130

How many numbers of sessions can one group in batches?

1035

How will the document be delivered to me?

1033

What is the function of union transformation?

1081

How you know when to use a static cache and dynamic cache in lookup transformation?

1815

How to load data in informatica ?

971

What are active transformations.

1611

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1463

How can you define user defied event?

993

Explain the informatica workflow?

1021

What are the main issues while working with flat files as source and as targets ?

1121

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1996

Briefly describe lookup transformation?

995