111111111111ravi11111111kumar11111111111?
i want display ravi kumar using sql?

Answer Posted / rathnakumar

select replace('111111111111ravi11111111kumar11111111111','1','') from dual;

Is This Answer Correct ?    17 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What differs when we choose the sorted input for aggregator transformation?

669


What is difference between a gateway node and worker node?

734


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1725


How can we store previous session logs?

658


without table how to come first record only in oracle?

1940






What are the restrictions of union transformation?

672


How can you validate all mappings in the repository simultaneously?

896


How are indexes created after completing the load process?

1094


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1314


While migrating the data from one environment to another environment how would you manage the connections?

723


How to update or delete the rows in a target, which do not have key fields?

761


What is aggregator transformation in informatica?

628


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1438


What is the difference between Active and Passive transformation?

736


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

879