Skip to Main Content

desc the v$ tables

BrianDwyerApr 29 2016 — edited May 5 2016

Hello, was just trying out a few things on SQLcl and wanted to confirm a few details of the database that i was connected to like database name and hostname, couldn't remember if it was hostname or host_name in v$instance so typed in desc v$instance and got the message back Usage: DESCRIBE [schema.]object[@db_link]

I know INFO brings it back but I would have though DESC would have still worked for the V$ tables as it works for user tables.

cheers

Brian

Comments
Post Details
Added on Apr 29 2016
4 comments
1,017 views