From the course: Oracle Database 19c: Basic SQL
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Using DESCRIBE in SQL*Plus
From the course: Oracle Database 19c: Basic SQL
Using DESCRIBE in SQL*Plus
- One of the first commands you'll probably run in a command line environment is the DESCRIBE command to find the details on several types of objects in the database. You'll typically run it in a command line environment, but I'll show you other places where you might run it and how you will run it. What is the syntax of the DESCRIBE command? It's probably one of the most straightforward commands you'll run second only to EXIT or QUIT. Here's the syntax, if you don't own the object in your own schema, you'll need to provide the schema name of the owner and you'll be able to see the definition only if you have the select any catalog privilege. The object can be a table view and many objects you might not expect. Finally, if the object you're describing is on another database, you'll have to provide an existing database link that references the remote database. Let's try a couple of examples. I'll open a terminal window in Linux and connect to the database with SQL*PLus as the HR user…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.