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 |
What are the advantages of using informatica as an etl tool over teradata?
what is the difference between mapplet & stored procedure?
if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.
I have a flat file, want to reverse the contents of the flat file
where is the reject loader .
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
what is system requirement(SR) & business requirement(BR)?
why we use source qualifier transformation?
Explain why we use partitioning the session in informatica?
Diffrence between static and dynamic cache
HOW TO DELETE A RECORD FROM FLAT FILE
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?