I need an oracle query for convert Char to Integer?. Can any
one help me how to do this?

Answer Posted / rr

select to_number('5672345') from dual

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does a rank transform differ from aggregator transform functions max and min?

665


Explain the scenario which compels informatica server to reject files?

650


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1547


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

1912


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1042






How would you copy the content of one repository to another repository?

547


What are active transformations.

1183


tell me about your project functionality

1859


What is complex mapping?

631


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1860


Different circumstance which drives informatica server to expel records?

549


What is data transformation manager process?

615


What is pmcmd command?

668


Explain the informatica workflow?

582


What are the designer tools for creating transformations?

675