View Data Source: View
This selection shows you a summary of the selected view. The display has the following tabs:
- Structure: This tab is displayed by default. It displays any comments describing the view or 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 Oracle datatype of the attribute.
- Size: The size 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.
- View Lineage: This tab displays the lineage of the view, that is, how the view was derived. For a description of the display, see Lineage Viewer.
Copyright © 2006, 2008, Oracle. All rights
reserved.