Interested to Buy Any Domain ? << Click Here >> for more details...
If sal is null then replace it with min(sal). Can any one
write a query for this in oracle ?
Advance Thanks
- 7 Answers
- 10815 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / basavan
select nvl(sal,min(sal) from <table name>
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
What is standalone command task?
write a query to retrieve the latest records from the table sorted by version(scd)
What is the function of aggregator transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How you know when to use a static cache and dynamic cache in lookup transformation?
What happens when a session fails and you click on recover?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Describe data concatenation?
What are active and passive transformations?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
what are the Methods For Creating Reusable Transformations?
Which version configuration tool used in ur project?
What is informatica etl tool?
How do you migrate data from one environment to another?
Differentiate between Load Manager and DTM?
