I have name like INDIA in a column. I want display 1st line A,
2nd line N, 3rd line D, 4th line I, 5th line A in oracle data
base?
Answer / ganesh kumar
SELECT SUBSTR('INDIA',LEVEL,1) AS INDIA FROM DUAL CONNECT BY
LEVEL<=LENGTH('INDIA');
TRY THIS QUERY IT WILL WORKS CORRECTLY.
| Is This Answer Correct ? | 30 Yes | 6 No |
If the records doesnt satisfy the filter condition where will it go?
replace multiple spaces with single space.
Explain lookup transformation source types in informatica
What are the new features of informatica 7.1?
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
Differentiate between source qualifier and filter transformation?
what is the diff b/w union and joiner and lookup?
What is union transformation in informatica?
how to load dimension table and fact table. plz tell me the steps.
Did u used latest transformations of 8.6.0? for what?
What is status code?
what are the output files that the informatica server creats during running a session?