Interested to Buy Any Domain ? << Click Here >> for more details...
1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
- 10 Answers
- 14681 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sunny
select substr(
(select substr('123*456*789', 1 ,
instr('123*456*789','*',1,2)-1) from dual)
,instr(
(select substr('123*456*789', 1 ,
instr('123*456*789','*',1,2)-1) from dual)
,'*',1)+1) from dual;
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
can u any challenge your project?
What are the new features of Power Center 5.0?
what are 3 tech challenges/ common issues you face?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What does “tail –f” command do and what is its use as an Informatica admin.
How we can create indexes after completing the loan process?
Under which circumstances, informatica server creates reject files?
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?
In informatics server which files are created during the session rums?
can anyone explain me about retail domain project in informatica?
What are different types of transformations available in informatica?
what is the hint? how to use it to reduce the query processing in program?
What are the main features of Oracle 8i with context to datawarehouse?
Define Pmrep command?
Difference between Data and Index Caches?
