my name is amar i want display 1st line A 2nd line M 3rd line
A 4th line R in database & informatica
- 1 Answers
- 3607 Views
- HCL, I also Faced
- E-Mail Answers
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 |
How to delete data which is not in source table?
0 Answers IBM, Saama Tech, Wipro,
What are the steps involved in etl process?
what happens if the info.server doesn't find the session parameter in the parameter file?
What is meant by incremental load?
what do u do when DB time takes more?in sap bi
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
what are the facilities provided by data warehouse to analytical users?
How many steps etl contains explain with example?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
what are the facilities provided by OLAP to analytical users?
what is the difference steps for data modeling?
explain the methodology of Data Warehousing?(Polaries)
Teradata 
