1
2
3
*
4
5
6
*
7
8
9
how to load records between two stars(*),
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
How do you use reject loader.
What are the types of caches in lookup?
Is it possible to define a single node as a Gateway node as well as worker node?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is mapping debugger?
What are pre and post-session shell commands?
What are ETL Tools?
What is a snowflake schema?
differences between service based and product based?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is different between the data warehouse and data mart?
Describe data concatenation?
What is target designer and target load order?
What is depict expression change?
What is pmcmd command?