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

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  


what is the difference between mapplet & stored procedure?

1 Answers  


if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,


I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,


where is the reject loader .

1 Answers  


If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  


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

2 Answers   Ness Technologies,


why we use source qualifier transformation?

16 Answers   Accenture,


Explain why we use partitioning the session in informatica?

0 Answers  


Diffrence between static and dynamic cache

2 Answers   HCL,


HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

0 Answers  


Categories