Re: Size on cloumns
From: tmasagai <mz_at_zafad.org>
Date: Tue, 15 Oct 2002 09:51:58 +0200
Message-ID: <3dabca59_at_news.mhogaming.com>
Date: Tue, 15 Oct 2002 09:51:58 +0200
Message-ID: <3dabca59_at_news.mhogaming.com>
Think you very much,
I try :
select DATA_TYPE, DATA_LENGTH, COLUMN_NAME from all_tab_columns where table_name = 'MyTable'
And it works very good.
MZ
Daniel Morgan a écrit dans le message
<3DA6EFD7.138F9139_at_exesolutions.com>...
>tmasagai wrote:
>
>> I search one request that return a size of each column in one table?
>
>Do a describe (DESC) on all_tab_columns
>
>You will find what you are looking for.
>
>Daniel Morgan
>
Received on Tue Oct 15 2002 - 09:51:58 CEST