|
Step 8 - Managing Tables
|
Learn Oracle - Viewing Tables
To view a table, click Tables on the Administration page of Enterprise Manager.
Initially, Oracle DBA see the tables for the schema that Oracle DBA are logged into. To see tables in
other schemas, click the flashlight adjacent to the Schema box to select another schema,
then click Go for the results to be displayed. For example, Oracle DBA can specify HR as your
schema and EMPLOYEES as the table.
To view a table definition, from the Results list, either click the link in the Table Name
column or select a table, such as HR.EMPLOYEES, then click View.
Viewing Table Data
To view data in a table from the Tables property page, select the table, then select View
Data, from the Actions drop down menu, and click Go. A View Data For Table page
appears showing the row data in the Results section.
To sort data in a column, Oracle DBA can click any column name.
To change the query, click Refine Query. The Refine Query page lets Oracle DBA select the
columns to display. It also lets Oracle DBA specify a WHERE clause for the SQL statement to
limit the results.
Oracle DBA can write your own SQL query using a SELECT statement to see the contents of a
table. Oracle DBA can execute SQL statements by starting an iSQL*Plus session from
Enterprise Manager’s Database Maintenance property page.
|
|
|
