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 6694 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database SQL Language Reference, 11g Release 1 (11.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, 11g Release 1 (11.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 SQL Language Reference, 11g Release 1 (11.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 Administrator's Guide, 11g Release 1 (11.1)

Scheduler Reference

View Description*_SCHEDULER_CHAIN_RULES These views show all rules for all chains. *_SCHEDULER_CHAIN_STEPS These views show all steps for all chains. *_SCHEDULER_CHAINS These views show all chains. *_SCHEDULER_CREDENTIALS These views show all credentials. *_SCHEDULER_GLOBAL_ATTRIBUTE These views show the current values of Scheduler attributes. *_SCHEDULER_JOB_ARGS These views show all set argument values for all

Database SQL Language Reference, 11g Release 1 (11.1)

ALTER MATERIALIZED VIEW

ALTER MATERIALIZED VIEWPurpose A materialized view is a database object that contains the results of a query. The FROM … are called the master databases. Use the ALTER MATERIALIZED VIEW statement to modify an existing … materialized view in one or more of the following ways: To change its storage characteristics To change … materialized view

Database SQL Language Reference, 11g Release 1 (11.1)

CREATE MATERIALIZED VIEW LOG

CREATE MATERIALIZED VIEW LOGPurpose Use the CREATE MATERIALIZED VIEW LOG statement to create a materialized view log, which is … a table associated with the master table of a materialized view. Note: The keyword SNAPSHOT is … supported in place of MATERIALIZED VIEW for backward compatibility. When DML changes are made to master … table data,

Database SQL Language Reference, 11g Release 1 (11.1)

DROP MATERIALIZED VIEW

DROP MATERIALIZED VIEWPurpose Use the DROP MATERIALIZED VIEW statement to remove an existing materialized view from the … database. When you drop a materialized view, Oracle Database does not place it in the recycle bin … . Therefore, you cannot subsequently either purge or undrop the materialized view. Note: The keyword … SNAPSHOT

Database SQL Language Reference, 11g Release 1 (11.1)

DROP MATERIALIZED VIEW LOG

DROP MATERIALIZED VIEW LOGPurpose Use the DROP MATERIALIZED VIEW LOG statement to remove a materialized view log from the … database. Note: The keyword SNAPSHOT is supported in place of MATERIALIZED VIEW for backward … compatibility. See Also: CREATE MATERIALIZED VIEW and ALTER MATERIALIZED VIEW for more information on

Database SQL Language Reference, 11g Release 1 (11.1)

CREATE MATERIALIZED VIEW

CREATE MATERIALIZED VIEWPurpose Use the CREATE MATERIALIZED VIEW statement to create a materialized view. A materialized … view is a database object that contains the results of a query. The FROM clause of the query can name … : The keyword SNAPSHOT is supported in place of MATERIALIZED VIEW for backward compatibility. For … feature.

Database SQL Language Reference, 11g Release 1 (11.1)

ALTER MATERIALIZED VIEW LOG

ALTER MATERIALIZED VIEW LOGPurpose A materialized view log is a table associated with the master table of a materialized view … . Use the ALTER MATERIALIZED VIEW LOG statement to alter the storage characteristics or type of an … existing materialized view log. Note: The keyword SNAPSHOT is supported in place of MATERIALIZED VIEW

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Views

Updating a Join ViewAn updatable join view (also referred to as a modifiable join view ) is a view that contains more … , UPDATE, or DELETE operation on a join view can modify only one underlying base table at a time … . UPDATE Rule All updatable columns of a join view must map to columns of a key-preserved table. See \"Key

Database Administrator's Guide, 11g Release 1 (11.1)

Investigating, Reporting, and Resolving a Problem

Task 2 -View Problem DetailsYou continue your investigation with the Problem Details page. To view problem details: On the … Incident page or Data Failure page, click View Problem Details. The Problem Details page appears … , showing the Incidents subpage. (Optional) To view incident details, select an incident, and then click … View. The

Database Data Warehousing Guide, 11g Release 1 (11.1)

Integrity Constraints

View ConstraintsYou can create constraints on views. The only type of constraint supported on a view is a RELY

Database SQL Language Reference, 11g Release 1 (11.1)

SQL Statements: ALTER MATERIALIZED VIEW to ALTER SYSTEM

11 SQL Statements: ALTER MATERIALIZED VIEW to ALTER SYSTEMThis chapter contains the following SQL statements: ALTER MATERIALIZED VIEW ALTER MATERIALIZED VIEW

Database Administrator's Guide, 11g Release 1 (11.1)

Investigating, Reporting, and Resolving a Problem

Task 1 - View Critical Error Alerts in Enterprise Manageralerts on the Database Home page. To view critical error alerts: Access the Database Home page in … to view the details of the problem associated with the critical error alert that you are … investigating, proceed with Task 2 -View Problem Details. If the graphical timeline shows a large number of … different problems over the

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Views

Expansion of Defining Queries at View Creation TimeWhen a view is created, Oracle Database expands any wildcard (*) in a top-level view query into a … query to be syntactically correct. As an example, assume that the dept view is created as follows … : CREATE VIEW dept AS SELECT * FROM scott.dept; The database stores the defining query of the dept view

Database Reference, 11g Release 1 (11.1)

Dynamic Performance View Descriptions

Dynamic Performance View Descriptionsthe \"Next\" button to go to the first dynamic performance view.

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Materialized Views

Materialized View LogsMaterialized view logs are required if you want to use fast refresh, with the exception of PCT … refresh. That is, if a detail table supports PCT for a materialized view, the materialized view log on … that detail table is not required in order to do fast refresh on that materialized view. As a general … rule,

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Materialized Views

Materialized View Schema DesignSummary management can perform many useful functions, including query rewrite and materialized view … realize significantly greater query execution performance and materialized view refresh performance … guidelines. A materialized view definition includes any number of aggregates, as well as any number of … joins. In several ways,

Database Data Warehousing Guide, 11g Release 1 (11.1)

Basic Materialized Views

Analyzing Materialized View Capabilitiesview or potential materialized view. In particular, this procedure enables you to determine: If a … materialized view is fast refreshable What types of query rewrite you can perform with this … materialized view Whether PCT refresh is possible Using this procedure is straightforward. You simply call … DBMS_MVIEW.EXPLAIN_MVIEW,