Testing for datatype in columns?

From: <rune.slinning_at_bigfoot.com>
Date: Fri, 17 Jul 1998 01:37:17 GMT
Message-ID: <6om9sd$cm6$1@nnrp1.dejanews.com>

Hi All!

I have a table DOCUMENT with the following columns:

doc_no       varchar2(30),
revision     varchar2(30),
issue_date   varchar2(30)

I need a query to check if the content of the revision column is numeric and the content of the issue_date is a date.

I would need a query with similar functionality as the ones below:

select doc_num, revision
from document
where revision is not numeric;

select doc_num, issue_date
from document
where issue_date is not date;

Thanks,
Rune

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 16 1998 - 20:37:17 CDT