select to_number('5672345') from dual

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

Question Posted / rr

Answer Posted / rr

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

1287

What if the source is a flat-file?

1063

How to do the error handling of if ur source is flatfiles?

1930

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2303

What happens when a session fails and you click on recover?

1093

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6960

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1932

In how many ways we can create ports?

1083

Please let me know how to make Data masking in informatica..

1683

How to generate sequence numbers without using the sequence generator transformation?

1155

What is Index Caches size?

1076

What is difference between a gateway node and worker node?

1088

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2016

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3834

Where do we use mapping variables in informatica?

1017