Posted by Andy Hassall on 07/02/07 18:31

On Mon, 02 Jul 2007 12:33:08 GMT, Mladen Gogala
<mgogala.SPAM_ME.NOT@verizon.net> wrote:

>On Sat, 30 Jun 2007 05:45:00 +0000, cbtguy_2000 wrote:
>
>> The following SELECT gives the basic same info as DESCRIBE
>
>It does, but it will not work for views or V$ tables.

Um, yes it will. Views' columns appear in USER_TAB_COLUMNS.

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Back to original message]