SELECT SUBSTR('INDIA',LEVEL,1) AS INDIA FROM DUAL CONNECT BY LEV

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?

Question Posted / ganesh kumar

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Whats there in global repository

1641

Explain why we use partitioning the session in informatica?

1006

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1986

What is domain in terms of informatica?

952

What is xml source qualifier transformation in informatica?

1175

Name the different lookup cache(s)?

1158

Which is the t/r that builts only single cache memory?

1126

What is a sorter transformation?

1037

How many ways are there to create ports?

1234

How to extract sap data using informatica?

984

What are the informatica performance improvement tips

1017

What is parallel processing in informatica?

1619

Explain the types of lookup transformation?

978

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8170

What is pmcmd command?

1045