Interested to Buy Any Domain ? << Click Here >> for more details...
I have name like INDIA in a column. I want display 1st line A,
2nd line N, 3rd line D, 4th line I, 5th line A in oracle data
base?
- 1 Answers
- 9167 Views
- Cognizant, HCL, I also Faced
- E-Mail Answers
Answer Posted / ganesh kumar
SELECT SUBSTR('INDIA',LEVEL,1) AS INDIA FROM DUAL CONNECT BY
LEVEL<=LENGTH('INDIA');
TRY THIS QUERY IT WILL WORKS CORRECTLY.
| Is This Answer Correct ? | 30 Yes | 6 No |
Post New Answer View All Answers
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is a joiner transformation?
How is union transformation utilized?
How can we update a record in the target table without using update strategy?
What is deployment group?
What is lookup change?
Why update strategy and union transformations are active?
What is persistent lookup cache?
In which transformation you cannot drag ports into it?
How can we delete duplicate rows from flat files?
Explain transaction control transformation in informatica
hi real timers . iam waiting for ur reply regarding ETL TESTING
list out all the transformations which use cache?
How to use procedural logic inside infromatica?
What are the main issues while working with flat files as source and as targets ?
