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



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

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

More ETL Interview Questions

How many types of transformations supported by sorted input?

0 Answers  


When do we go for the tools in the market?

0 Answers  


What is a lookup table in etl?

0 Answers  


Define Dynamic push down optmization?

0 Answers   HP,


can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

0 Answers   Cap Gemini,






what is the meant by Normalization and de-normalization?

2 Answers  


Two default user groups created in the repository are____and_____.

0 Answers  


please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

0 Answers  


what are the facilities provided by OLAP to analytical users?

1 Answers  


What are the names of the layers in etl?

0 Answers  


What are various etl tools in the market?

0 Answers  


what are the facilities provided by data warehouse to analytical users?

0 Answers  


Categories