12-2. Obtaining Information About Tables
Problem
You are interested in learning more about a particular database table. You also want to look at system triggers and other privileged PL/SQL objects.
Solution
Use the Oracle SQL Developer navigator to select the table that you want to view information about, as demonstrated in Figure 12-3.
Figure 12-3. Viewing table information
The editor window will then populate with a tab that consists of a worksheet and several subtabs. Each of these tabs provides different information about the table you are inspecting. Figure 12-4 shows the Columns tab of the Table Editor.
Figure 12-4. Table Editor ...
Get Oracle and PL/SQL Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
