to:
05/21/2001 Subject:
Re: Check for number only
05:24 PM
:
Sent by: Fax to:
[EMAIL PROTECTED]Subject: Check for number
only m
05/18/2001
12:17 PM
Please respond
to ORACLE-L
I have a table with a column of varchar2
Still
jkstill@cybcTo: [EMAIL PROTECTED],
[EMAIL PROTECTED] on.com cc:
Fax to:
05/21/2001 Subject: Re: Check for number
only 05:24 PM
Diane,
If you rely on Oracle to do
I have a table with a column of varchar2(50) datatype. We are building a
new table and the values in this column should all be numbers. I need to
query the table to find all rows which have a value in this column which is
not a valid number.
Table:
circuit (circ_id (primary_key) number,
Glenn,
something like ...
where LTRIM (circ_num, '0123456789.') is not null
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of
Try
TO_NUMBER(circ_num)
and exception INVALID_NUMBER
Jan Pruner
-Original Message-
From: Glenn Travis [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 6:17 PM
To: Multiple recipients of list ORACLE-L
Subject: Check for number only
I have a table with a column of varchar2
by: Subject: RE: Check for number only
[EMAIL PROTECTED
to:
[EMAIL PROTECTED]Subject: Check for number only
m