Home » RDBMS Server » Server Administration » numeric varchar2
numeric varchar2 [message #370997] Wed, 02 August 2000 06:43 Go to next message
Mark Lamport
Messages: 1
Registered: August 2000
Junior Member
I have a field in a table that is defined varchar2. I need to perform a numeric select though. The contents of the field might contain a blank. I think you use the to_num but can't find documentaion or example.

Re: numeric varchar2 [message #371080 is a reply to message #370997] Thu, 24 August 2000 03:42 Go to previous message
Jaya Kumar NM
Messages: 11
Registered: August 2000
Junior Member
You can try this
select to_number(nvl(column_name,0)) from table_name
Previous Topic: Re: Sending E-Mail from Oracle
Next Topic: Re: @corelated subquery
Goto Forum:

Current Time: Thu Oct 22 05:01:46 CDT 2020