View Data Source: Table
This selection shows you a summary of the selected table. The tabs are as follows:
- Structure: This tab is displayed by default. It displays any comments describing the table (if there are any comments) and, in a grid, information about each attribute in the table or view. The following information is displayed for each attribute:
- PK: A check mark indicates that the attribute is a primary key; an X indicates that the attribute is not a primary key.
- Name: The name of the attribute.
- Type: The datatype of the attribute.
- Size: The length of the attribute.
- Scale: The scale for the attribute (numeric attributes only).
- Allow NULLS: A check mark indicates that the attribute can be
NULL
; an X indicates that the attribute cannot be NULL
.
- Data: This tab displays, by default, the first 100 rows (cases) of data. You control the display of rows as follows:
- To change the number of rows displayed, change Fetch size and click Refresh.
- To display the next set of rows, click Fetch Next; the next N rows, where N = Fetch size, are appended to the grid. If all data is displayed, this button is grayed out.
- To refresh the display, click Refresh.
Copyright © 2006, 2008, Oracle. All rights
reserved.