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

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2052

What is a router transformation?

1210

Enlist the tasks for which source qualifier transformation is used.

1072

Which transformation is needed while using the Cobol sources as source definitions?

1218

What are the new features of Power Center 5.0?

1846

What is the difference between source qualifier transformations source filter to filter transformation?

1092

Name the different lookup cache(s)?

1292

Repository user profiles

1811

if we have a delimiters at unwanted places in a flat file how can we over come those.

2085

Enlist the various types of transformations.

1118

How many ways a relational source definition can be updated and what are they?

1061

difference between informatica 8.1.1 and 8.6

3729

What is dynamic cache?

1085

what is the complex transformation you used in informatica

2622

Can you use flat files in Mapplets.

2710