111111111111ravi11111111kumar11111111111?
i want display ravi kumar using sql?

Answer Posted / murali

In expr_trns we can use---

REPLACECHR (
1, "111111111111ravi11111111kumar11111111111" , '1', NULL)


Thanks,
Murali Udayagiri

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the cumulative sum and moving sum?

865


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2011


Explian the Process of deployment groups in informatica

730


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6639


How to join three sources using joiner?

670






How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

789


How is union transformation utilized?

675


Performance tuning in UNIX for informatica mappings?

2246


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1792


Explain dynamic target flat file name generation in informatica

731


Which are the different editions of informatica powercenter that are available?

666


What is workflow? What are the components of the workflow manager?

747


what is diff b/t sorter t/r and agg have the option sorter property...

1852


Difference between Data and Index Caches?

766


What is repository manager?

632