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
- 9196 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
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is pmcmd command?
What are the different clients of powercenter?
tell me 5 session failure in real time how can you solve that in your project?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are multi-group transformations?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to go to the older version for a mapping?
differences between service based and product based?
How to update source definition?
How to improve the performance of a session using sorter transformation?
How can we create index after completion of load process?
What is the benefit of partitioning a session?
What is meant by pre and post session shell command?
