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 the reports developed in sap bw project and what is the requirement for developing it?

1776


What is etl process? How many steps etl contains?

599


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

1360


what are the concerns of OLTP and DSS systems?

1559


What is abap? What are idocs?

516






What is partitioning? Explain different types of partitioning?

668


tell me few points when u become TL

2027


What are your responsibilities as an etl tester?

629


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

555


What are the different Lookup methods used in Informatica?

520


how does the server recongnise the source and target databases.Elaborate on this

2101


Identifying the bottlenecks in various components of Informatica and resolving them.

1508


Can anyone explain me a scenario from banking and finance...more precisely a mapping

2065


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

619


What is tracing level?

629