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.

thanks

Report message to a moderator

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

Report message to a moderator

Previous Topic: Re: Sending E-Mail from Oracle 8.0.6.0.0
Next Topic: Re: @corelated subquery
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 01 09:14:21 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.