You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for view


1 to 20 of 8643 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database PL/SQL Language Reference, 12c Release 1 (12.1)

Overview of PL/SQL

The %ROWTYPE attribute lets you declare a record that represents either a full or partial row of a database…either a full or partial row of a database table or view. For every column of the full or partial row

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Collections and Records

The %ROWTYPE attribute lets you declare a record that represents either a full or partial row of a database…always represents a full row of a database table or view, use this syntax: variable_name … table_or_view_name%ROWTYPE; For every column of the table or view, the record has a field with the same name and … to Example 5-34. Live SQL: You can view and run this example on Oracle Live SQL at %ROWTYPE … values or NOT NULL constraints.

Database SQL Language Reference, 12c Release 1 (12.1)

CREATE VIEW

CREATE VIEWPurpose Use the CREATE VIEW statement to define a view, which is a logical table based on one or … more tables or views. A view contains no data itself. The tables upon which a view is based are called … base tables. You can also create an object view or a relational view that supports

Database SQL Language Reference, 12c Release 1 (12.1)

ALTER VIEW

ALTER VIEWPurpose Use the ALTER VIEW statement to explicitly recompile a view that is invalid or to modify … view constraints. Explicit recompilation lets you locate recompilation errors before run time. You may … want to recompile a view explicitly after altering one of its base tables to ensure that the … alteration does

Database SQL Language Reference, 12c Release 1 (12.1)

DROP VIEW

DROP VIEWPurpose Use the DROP VIEW statement to remove a view or an object view from the database. You can … change the definition of a view by dropping and re-creating it. See Also: CREATE VIEW and ALTER VIEW … for information on creating and modifying a view Prerequisites The

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Space for Schema Objects

View Descriptionspecific to the Automatic Segment Advisor. View Description DBA_AUTO_SEGADV_SUMMARY Each row of this … view summarizes one Automatic Segment Advisor run. Fields include number of tablespaces and segments

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Views, Sequences, and Synonyms

View DescriptionDALLAS 7566 JONES 20 RESEARCH DALLAS 8 rows selected. In this view, emp is a key-preserved table … INSERT statement on a join view can modify only one underlying base table. 24.1.5.3.1 UPDATE Statements … example shows an UPDATE statement that successfully modifies the emp_dept view: UPDATE emp_dept SET sal … view:

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Data Files and Temp Files

View Descriptionpresented here. View Description V$MAP_LIBRARY Contains a list of all mapping libraries that have been

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Space for Schema Objects

View Descriptionset of views for information about the status of resumable statements. View Description … suspended the session invoking the statement is put into a wait state. A row is inserted into this view

Database Administrator's Guide, 12c Release 1 (12.1)

Monitoring the Database

View DescriptionAlerts You can view and change threshold settings for the server alert metrics using the SET_THRESHOLD … view. For example: SELECT metrics_name, warning_value, critical_value, consecutive_occurrences FROM … easiest way to view server-generated alerts is by accessing the Database Home page of Cloud Control … Control to display

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Legacy Tables and Views

6.8.2 MDSYS.SDO_ANGLE_UNITS ViewThe MDSYS.SDO_ANGLE_UNITS reference view contains one row for each valid angle UNIT specification … Well-Known Text (WKT). The MDSYS.SDO_ANGLE_UNITS view is based on the SDO_UNITS_OF MEASURE table … -29 MDSYS.SDO_ANGLE_UNITS View Column Name Data Type Description SDO_UNIT VARCHAR2(32) Name of the

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Coordinate Systems Data Structures

6.7.14 SDO_CRS_GEOCENTRIC ViewThe SDO_CRS_GEOCENTRIC view contains selected information from the SDO_COORD_REF_SYS table … (described in SDO_COORD_REF_SYS Table ) where the COORD_REF_SYS_KIND column value is GEOCENTRIC. This view … contains the columns shown in Table 6-13. Table 6-13 SDO_CRS_GEOCENTRIC View Column Name Data Type

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Coordinate Systems Data Structures

6.7.17 SDO_CRS_PROJECTED ViewThe SDO_CRS_PROJECTED view contains selected information from the SDO_COORD_REF_SYS table … (described in SDO_COORD_REF_SYS Table ) where the COORD_REF_SYS_KIND column value is PROJECTED. This view … contains the columns shown in Table 6-16. Table 6-16 SDO_CRS_PROJECTED View Column Name Data Type

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Coordinate Systems Data Structures

6.7.19 SDO_DATUM_ENGINEERING ViewThe SDO_DATUM_ENGINEERING view contains selected information from the SDO_DATUMS table (described … in SDO_DATUMS Table ) where the DATUM_TYPE column value is ENGINEERING. This view contains the … columns shown in Table 6-18. Table 6-18 SDO_DATUM_ENGINEERING View Column Name Data Type Description

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Legacy Tables and Views

6.8.3 MDSYS.SDO_AREA_UNITS ViewThe MDSYS.SDO_AREA_UNITS reference view contains one row for each valid area UNIT specification in … Well-Known Text (WKT). The MDSYS.SDO_AREA_UNITS view is based on the SDO_UNITS_OF MEASURE table … SDO_AREA_UNITS View Column Name Data Type Purpose SDO_UNIT VARCHAR2 Values are taken from the

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Coordinate Systems Data Structures

6.7.12 SDO_CRS_COMPOUND ViewThe SDO_CRS_COMPOUND view contains selected information from the SDO_COORD_REF_SYS table (described … view contains the columns shown in Table 6-11. Table 6-11 SDO_CRS_COMPOUND View Column Name Data Type

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Coordinate Systems Data Structures

6.7.15 SDO_CRS_GEOGRAPHIC2D ViewThe SDO_CRS_GEOGRAPHIC2D view contains selected information from the SDO_COORD_REF_SYS table … view contains the columns shown in Table 6-14. Table 6-14 SDO_CRS_GEOGRAPHIC2D View Column Name Data

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Coordinate Systems Data Structures

6.7.21 SDO_DATUM_VERTICAL ViewThe SDO_DATUM_VERTICAL view contains selected information from the SDO_DATUMS table (described in … SDO_DATUMS Table ) where the DATUM_TYPE column value is VERTICAL. This view contains the columns … shown in Table 6-20. Table 6-20 SDO_DATUM_VERTICAL View Column Name Data Type Description DATUM_ID

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Coordinate Systems Data Structures

6.7.18 SDO_CRS_VERTICAL ViewThe SDO_CRS_VERTICAL view contains selected information from the SDO_COORD_REF_SYS table (described … in SDO_COORD_REF_SYS Table ) where the COORD_REF_SYS_KIND column value is VERTICAL. This view … contains the columns shown in Table 6-17. Table 6-17 SDO_CRS_VERTICAL View Column Name Data Type

Spatial and Graph Developer's Guide, 12c Release 1 (12.1)

Coordinate Systems Data Structures

6.7.10 SDO_COORD_REF_SYSTEM ViewThe SDO_COORD_REF_SYSTEM view contains the same columns as the SDO_COORD_REF_SYS table, which is … described in SDO_COORD_REF_SYS Table. However, the SDO_COORD_REF_SYSTEM view has a trigger defined on … it, so that any insert, update, or delete operations performed on the view cause all relevant … need to perform an insert, update,