Skip to Main Content

"desc" doesnt work for v$ tables

KunwarJun 7 2016 — edited Jun 12 2016

Hi,

I am using

++++++++++

SQLcl: Release 4.2.0.16.131.1023 RC on Tue Jun 07 22:10:19 2016

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

++++++++++

desc works for normal tables but doesnt v$ objects. How to fix it?

22:22:37 m937TMP_3@ACSDP0TMP_> desc test

Name Null? Type

---- ----- ------

ID         NUMBER

22:22:40 m937TMP_3@ACSDP0TMP_> desc v$session

Usage: DESCRIBE [schema.]object[@db_link]

Regds,

Kunwar

Comments
Post Details
Added on Jun 7 2016
3 comments
760 views