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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Post New Answer

More Informatica Interview Questions

If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,

replace multiple spaces with single space.

3 Answers   IBM,

Explain lookup transformation source types in informatica

0 Answers   Informatica,

What are the new features of informatica 7.1?

2 Answers  

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,

Differentiate between source qualifier and filter transformation?

0 Answers  

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

4 Answers  

What is union transformation in informatica?

0 Answers  

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

Did u used latest transformations of 8.6.0? for what?

0 Answers  

What is status code?

2 Answers  

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories