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?
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
Which development components of informatica have the highest usage?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
Explain the difference between a data warehouse and a data mart?
Why union transformation is an active transformation?
What are the performance considerations when working with aggregator transformation?
What is aggregator transformation in informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is the sql query overwrite in source qualifier in informatica
How to elaborate powercenter integration service?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is the session task and command task?
What are different types of transformations available in informatica?