update emp_test set comm=(select min(sal) from emp

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

Advance Thanks

Question Posted / abc

Answer Posted / abc

update emp_test set comm=(select min(sal) from emp_test)
where comm is null;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

998

How to differentiate between the active and passive transformations?

1075

How can you generate reports in informatica?

972

What is intricate mapping?

1091

Design a mapping to load a target table with the following values from the above source?

1284

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1200

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1031

What are active and passive transformations?

1020

What are the various types of transformation?

1094

How to load last n records of file into target table - informatica

1018

During the running session, output files are created by informatica server. Enlist few of them.

930

How do you update the records with or without using update strategy?

1054

What are the new features of informatica 9.x in developer level?

937

Parameter and variable differences

2005

To import the flat file definition into the designer where should the flat file be placed?

1004