Skip to Main Content
Oracle SQL*Plus: The Definitive Guide
book

Oracle SQL*Plus: The Definitive Guide

by Jonathan Gennick
March 1999
Intermediate to advanced content levelIntermediate to advanced
528 pages
14h 39m
English
O'Reilly Media, Inc.
Content preview from Oracle SQL*Plus: The Definitive Guide

Finding More Information

It’s well worth your time to learn more about Oracle’s data dictionary views. Anything you want to know about the structure of your database and the objects within it can be found by querying the appropriate view. The definitive reference for these views is the Oracle8 Server Reference manual. However, if you don’t have that manual close by, you can get a quick list of useful views by executing the following query:

SELECT *
  FROM dictionary
ORDER BY table_name;

Use the DESCRIBE command on any views of interest. The column names tend to be reasonably self-explanatory.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Jonathan Gennick
Oracle PL/SQL Programming, Third Edition

Oracle PL/SQL Programming, Third Edition

Steven Feuerstein, Bill Pribyl
Oracle SQL

Oracle SQL

Dan Hotka

Publisher Resources

ISBN: 1565925785Supplemental ContentCatalog PageErrata