Re: Select statement that returns field size?
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 05 May 2010 20:08:10 +0200
Message-ID: <4BE1B40A.1060408_at_gmail.com>
On 05.05.2010 20:05, Rich wrote:
>
> I am using 10g.
>
> I want to do a select statement that will give me the name of the
> fields in a table. And I also want to know the field type and field
> size.
>
> Can this be done?
>
> Regards
Date: Wed, 05 May 2010 20:08:10 +0200
Message-ID: <4BE1B40A.1060408_at_gmail.com>
On 05.05.2010 20:05, Rich wrote:
>
> I am using 10g.
>
> I want to do a select statement that will give me the name of the
> fields in a table. And I also want to know the field type and field
> size.
>
> Can this be done?
>
> Regards
Look up in the docs dba/all/user_tab_columns data dictionary view
Best regards
Maxim Received on Wed May 05 2010 - 13:08:10 CDT