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
View Creation Example → The 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,
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
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
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
Restrictions on Subviews → rows 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:
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
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.
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
MGW_MQSERIES_LINKS View → This 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
MGW_SUBSCRIBERS View → This 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
MGW_TIBRV_LINKS View → This 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
MGW_FOREIGN_QUEUES View → This 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
View Hierarchies → An 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
View Constraints → You 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
MGW_GATEWAY View → This 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
MGW_SCHEDULES View → Table 51-26 MGW_SCHEDULES View Properties Name Type Description SCHEDULE_ID VARCHAR2 Propagation
oramts_2pc_pending View → The 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
DBA_WM_SYS_PRIVS View → The DBA_WM_SYS_PRIVS metadata view (described in Section 5.17 ) contains information about all
View Menu → The 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