I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd

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 / cmr

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, ..

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

More Informatica Interview Questions

How can we use mapping variables in informatica? Where do we use them?

without dynamic lookup how to insert new rows and update existing rows?

Can anyone tell me the new features in Informatica 9 Version?

How we will implement Pushdown Optimization and Types in Informatica with better examples

can we load the data with out a primary key of a table? what is target plan?

Explain the difference between a data warehouse and a data mart?

What is repository manager?

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

What is the function of look up transformation?

Define sessions in informatica etl?

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

For more Informatica Interview Questions Click Here