Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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?



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

Post New Answer

More Informatica Interview Questions

Repository user profiles

0 Answers  


How many ways you create ports?

1 Answers  


what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,


why we use stored procedure transformation?

4 Answers   IBM,


error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers   CTS,


why we are using surogate key in real time give me explanation

2 Answers   TCS,


Explain factlessfact table with scenario

1 Answers   HCL,


what is the predefined port in dynamic lookup

2 Answers  


what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,


I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,


what is the diff b/w union and joiner and lookup?

4 Answers  


Categories