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

my name is amar i want display 1st line A 2nd line M 3rd line
A 4th line R in database & informatica

Answer Posted / lajpat kurdiya

SELECT SUBSTR('AMAR',LEVEL,1) AS Name
FROM DUAL
CONNECT BY LEVEL<= LENGTH('AMAR');

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are three tier systems in etl?

1066


Is apache nifi an etl tool?

962


what is the use of server manager?

2137


how do u set partition points in the mapping?

2596


where are the log files generally stored.Can you change the path of the file.what can the path be?

2440


What is a lookup table in etl?

1186


Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance

2236


Explain about the data integration suite features?

945


What are the etl testing operations includes?

1111


Difference between flat files and relational sources?

2309


Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

1993


what is different between sequential batch and concurrent batch and which is recommended and why?

4928


how to connect to a flatfile through ftp in informatica

14299


Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1772


Explain do we need an etl tool? When do we go for the tools in the market?

1013