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


2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

View Creation ExampleThe following example creates a view derived from the HR.EMPLOYEES table, which is part of the … sample schema. The view filters all direct reports for the manager Stephen King, whose employee_id is … 100. In an application scenario, this view adds an additional level of security to the HR.EMPLOYEES … create this view,

SQL Reference, 10g Release 1 (10.1)

CREATE VIEW

Restrictions on the Defining Query of a View, ROWNUM, or LEVEL pseudocolumns, then those columns must have aliases in the view subquery. If the … table, then the view will not contain those columns until you re-create the view by issuing a CREATE … OR REPLACE VIEW statement. For object views, the number of elements in the subquery select list … Views An

SQL Reference, 10g Release 1 (10.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

SQL Reference, 10g Release 1 (10.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

SQL Reference, 10g Release 1 (10.1)

CREATE VIEW

Restrictions on Subviewsrows of the table(s) that the view is based on. The select list of the subquery can contain up to … , and you must qualify them with a schema name in the view subquery. If you create a view with the … create time but rather each time a user subsequently queries the view. See Also: "Creating a Join … View:

SQL Reference, 10g Release 1 (10.1)

CREATE VIEW

Note: You cannot insert into the table using the view unless the view contains all NOT NULL columns…Examples Creating a View: Example The following statement creates a view of the sample table … employees named emp_view. The view shows the employees in department 20 and their annual salary: CREATE … VIEW emp_view AS SELECT last_name, salary*12 annual_salary FROM employees WHERE department_id = 20 … ; The view

SQL Reference, 10g Release 1 (10.1)

CREATE VIEW

Restrictions on Object Views If you try to dereference or pin a primary key REF that resolves to more…If the object view is defined on an object table or an object view, then you can omit this clause … identifier of the underlying object table or object view to uniquely identify each row. attribute For … identifier for the object view. UNDER Clause Use the UNDER clause to specify a subview based on an object superview.

SQL Reference, 10g Release 1 (10.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

Packages and Types Reference, 10g Release 1 (10.1)

51 DBMS_MGWADM

MGW_MQSERIES_LINKS ViewThis view lists information for the WebSphere MQ messaging system links. The view includes most of … MGW_MQSERIES_LINKS view properties. Table 51-22  MGW_MQSERIES_LINKS View Properties Name Type Description

Packages and Types Reference, 10g Release 1 (10.1)

51 DBMS_MGWADM

MGW_SUBSCRIBERS ViewThis view lists configuration and status information for Messaging Gateway subscribers. The view … status and statistical information. Table 51-25 lists the MGW_SUBSCRIBERS view properties. Table 51-25 …  MGW_SUBSCRIBERS View Properties Name Type Description SUBSCRIBER_ID VARCHAR2 Propagation

Packages and Types Reference, 10g Release 1 (10.1)

51 DBMS_MGWADM

MGW_TIBRV_LINKS ViewThis view lists information for TIB/Rendezvous messaging system links. The view includes most of … MGW_TIBRV_LINKS view properties. Table 51-23  MGW_TIBRV_LINKS View Properties Property Name Type Description

Packages and Types Reference, 10g Release 1 (10.1)

51 DBMS_MGWADM

MGW_FOREIGN_QUEUES ViewThis view lists information for foreign queues. The view includes most of the queue properties … specified when the queue is registered. Table 51-24 lists the MGW_FOREIGN_QUEUES view properties. Table … 51-24  MGW_FOREIGN_QUEUES View Properties Name Type Description NAME VARCHAR2 Name of the registered

Concepts, 10g Release 1 (10.1)

27 Object Datatypes and Object Views

View HierarchiesAn object view can be created as a subview of another object view. The type of the superview must … be the immediate supertype of the type of the object view being created. Thus, you can build an … object view hierarchy which has a one-to-one correspondence to the type hierarchy. This does not imply … that every

Guide, 10g Release 1 (10.1)

7 Integrity Constraints

View ConstraintsYou can create constraints on views. The only type of constraint supported on a view is a RELY … than tables. View constraints are particularly useful in OLAP environments, where they may enable more

Packages and Types Reference, 10g Release 1 (10.1)

51 DBMS_MGWADM

MGW_GATEWAY ViewThis view lists configuration and status information for Messaging Gateway, as shown in Table 51-20 … . Table 51-20  MGW_GATEWAY View Properties Name Type Description AGENT_STATUS VARCHAR2 Status of the

Packages and Types Reference, 10g Release 1 (10.1)

51 DBMS_MGWADM

MGW_SCHEDULES ViewTable 51-26  MGW_SCHEDULES View Properties Name Type Description SCHEDULE_ID VARCHAR2 Propagation

Developer's Guide, 10g Release 1 (10.1)

3 Managing Recovery Scenarios

oramts_2pc_pending ViewThe view oramts_2pc_pending is created by executing oramtsadmin.sql. oramts_2pc_pending shows in … -doubt transactions in the database. This view consists of the following columns: Formatid This is the

Application Developer's Guide - Workspace Manager, 10g Release 1 (10.1)

New and Changed Features

DBA_WM_SYS_PRIVS ViewThe DBA_WM_SYS_PRIVS metadata view (described in Section 5.17 ) contains information about all

Developer's Guide, 10g Release 1 (10.1)

View Menu (Oracle Workflow Developer's Guide)

View MenuThe View menu lets you alter the display of Oracle Workflow Builder. F ont-- Displays the Fonts … the View menu to determine the location and name of the log file. L og -> Bring to F ront-- Brings

Packages and Types Reference, 10g Release 1 (10.1)

51 DBMS_MGWADM

MGW_LINKS ViewThis view lists the names and types of messaging system links currently defined. Table 51-21 lists … the MGW_LINKS view properties. Table 51-21  MGW_LINKS View Properties Name Type Description