Using Structure and Data Tabs

After you display a table or view, you can alternate between the Structure and Data tab:

• The Structure tab shows all the structures contained in the table or view (column names and other attributes, constraints).
• The Data tab shows the data contained in each cell.

To change between Structure and Data tabs:

1. Display the table or view by selecting it from the appropriate navigator (Connections for online databases, System or Application for offline databases) and right-clicking Edit.
2. Click the Structure or Data tab in the Table or View editor to display it.

To display both the Structure and Data tabs:

1. Display the table or view by selecting it and right-clicking Edit.
2. Right-click the split viewer control above the vertical scroll bar on the top right, or the control to the immediate left of the lower right vertical scroll bar, and drag down to create a second viewer:
   
   
3. You can change the size of each viewer independently. Select the Structure tab in one viewer and the Data tab in another viewer to see structure and data at the same time.

Related topics

Browsing Databases

Copyright © 1997, 2004, Oracle. All rights reserved.