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

How big was your fact table

1859

Have you worked with/created Parameter file

1710

State the differences between sql override and lookup override?

1283

Difference between Target-based loading and constraint-based loading?

1042

What is source qualifier transformation in informatica?

1064

What is workflow monitor?

1099

What is Session and Batches?

1147

What does refresh system mean, and what are its distinctive choice?

1271

How to join three sources using joiner?

1192

difference between repository database and repository service?

1221

How can you differentiate between powercenter and power map?

1140

Global and Local shortcuts. Advantages.

2088

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1130

What are the designer tools for creating transformations?

1158

What does command task mean?

1215