How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
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
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.
CREATE VIEW → Purpose 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
ALTER VIEW → Purpose 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
DROP VIEW → Purpose 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
View Description → specific 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
View Description → DALLAS 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. 126.96.36.199.1 UPDATE Statements … example shows an UPDATE statement that successfully modifies the emp_dept view: UPDATE emp_dept SET sal … view:
View Description → presented here. View Description V$MAP_LIBRARY Contains a list of all mapping libraries that have been
View Description → set 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
View Description → Alerts 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
6.8.2 MDSYS.SDO_ANGLE_UNITS View → The 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
6.7.14 SDO_CRS_GEOCENTRIC View → The 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
6.7.17 SDO_CRS_PROJECTED View → The 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
6.7.19 SDO_DATUM_ENGINEERING View → The 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
6.8.3 MDSYS.SDO_AREA_UNITS View → The 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
6.7.12 SDO_CRS_COMPOUND View → The 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
6.7.15 SDO_CRS_GEOGRAPHIC2D View → The 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
6.7.21 SDO_DATUM_VERTICAL View → The 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
6.7.18 SDO_CRS_VERTICAL View → The 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
6.7.10 SDO_COORD_REF_SYSTEM View → The 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,