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 / 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 |
What is a configuration management?
Explain the flow of data in Iinformatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How to use Normalizer transformation?
Can I create one wrkflw which will run different wrkflws on schedule time?
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
explan ur project architecture?
Can you access a repository created in previous version of Informatica?
what is the difference between informatica6.1 and infomatica7.1
How to delete the (flat file) data in the target table after loaded.
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500