datefields on oracle server

#1

I need to locate all date fields in all tables ... could that be done using
some of this - or something else...?

http://www.windowsitpro.com/Article/...265/22265.html

#2

You could query the catalog tables. You could query
all_tab_columns - it has datatype as one of the columns so
you could filter it based on that.

-Sue

On Mon, 17 Oct 2005 09:29:48 +0200, "michael v"
<test (AT) test (DOT) com> wrote:

Quote:

I need to locate all date fields in all tables ... could that be done using
some of this - or something else...?

http://www.windowsitpro.com/Article/...265/22265.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

datefields on oracle server

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

datefields on oracle server - 10-17-2005 , 02:29 AM

Re: datefields on oracle server - 10-18-2005 , 08:48 PM