SELECT SUBSTR('AMAR',LEVEL,1) AS Name FROM DUAL CONNECT BY LE

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

Question Posted / lajpat kurdiya

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

Please Help Members By Posting Answers For Below Questions

What are the etl testing operations includes?

1156

What do you understand by active and passive transformations?

982

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

1056

how do u really know that paging to disk is happening while u are using a lookup transform?

2480

what is pmrep command?

2486

What are the ETL Testing Operations?

1100

Explain do we need an etl tool?

1074

what is data modeling?

1951

When do we analyze the tables?

1020

Explain etl mapping sheets?

1128

What do you understand by the term ‘transformation’?

1098

what are the data modeling tools you have used?(polaris)

2047

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1258

what is Forward,Reverse and Re_engineering?

2313

what is granularity in Data ware House?

1792