|
|
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
Navigation:
[Reply to this message]
|