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
Create → Instantiates a COM object in a COM Automation server. Syntax public void Create(String progID … ) public void Create(String progID, String serverName) Where Is progid the programmatic identifier (progID … ) of the COM Automation object to create. This character string describes the class of the COM … The COM Automation object
CREATE PACKAGE → Purpose Use the CREATE PACKAGE statement to create the specification for a stored package, which is … subsequently, defines these objects. See Also: CREATE PACKAGE BODY for information on specifying the … implementation of the package CREATE FUNCTION and CREATE PROCEDURE for information on creating
CREATE DIMENSION → Purpose Use the CREATE DIMENSION statement to create a dimension. A dimension defines a parent … dimension_join_clause of CREATE DIMENSION, you must run the DBMS_OLAP. VALIDATE_DIMENSION procedure … . See Also: CREATE MATERIALIZED VIEW for more information on materialized views Oracle Data … To create
CREATE USER → Purpose Use the CREATE USER statement to create and configure a database user, which is an account … have the CREATE USER system privilege. When you create a user with the CREATE USER statement, the … user's privilege domain is empty. To log on to Oracle Database, a user must have the CREATE
Restrictions on Temporary Tables Temporary tables cannot be partitioned, clustered, or index organized.… → absolute maximum number of columns in a table is 1000. However, when you create an object table or a
Restrictions on Trigger Conditions → If you specify this clause for a DML event trigger, then you must also specify FOR EACH ROW. Oracle Database evaluates this condition for each row affected by the triggering statement. You cannot specify trigger conditions for INSTEAD OF trigger statements. You can reference object columns or their attributes, or varray, nested table, or LOB columns. You cannot invoke PL/SQL functions or methods in
CREATE LIBRARY → Purpose Use the CREATE LIBRARY statement to create a schema object associated with an operating … -system shared library. The name of this schema object can then be used in the call_spec of CREATE … FUNCTION or CREATE PROCEDURE statements, or when declaring a function or procedure in a package or type … Also:
Restrictions on BEFORE Triggers → You cannot specify a BEFORE trigger on a view or an object view. You can write to the: NEW value but not to the: OLD value. AFTER Specify AFTER to cause the database to fire the trigger after executing the triggering event. For row triggers, the trigger is fired after each affected row is changed.
Restrictions on Triggers on UPDATE Operations → LOB column in the UPDATE OF clause. See Also: AS subquery clause of CREATE VIEW for a list of … to fire. You can create triggers for these events on DATABASE or SCHEMA unless otherwise noted. You … can create BEFORE and AFTER triggers for these events. Oracle Database fires the trigger in the … . CREATE Specify
Restrictions on Dimension Level Columns → All of the columns in a level must come from the same table. If columns in different levels come from different tables, then you must specify the dimension_join_clause. The set of columns you specify must be unique to this level. The columns you specify cannot be specified in any other dimension. Each level_column must be non-. However, these columns need not have NOT NULL constraints. hierarchy_clause
CREATE PROCEDURE → Purpose Use the CREATE PROCEDURE statement to create a standalone stored procedure or a call … for information about registering external procedures CREATE FUNCTION for information specific to … functions, which are similar to procedures in many ways CREATE PACKAGE for information on creating … packages. The CREATE
Restrictions on the Defining Query of a View → table, then the view will not contain those columns until you re-create the view by issuing a CREATE … create a view to be inherently updatable, or you can create an INSTEAD OF trigger on any view to make … delete base table rows. You can create a view to be inherently updatable, or you can create
CREATE CONTROLFILE → the CREATE CONTROLFILE statement to re-create a control file in one of the following cases: All … and open. An alternative to the CREATE CONTROLFILE statement is ALTER DATABASE BACKUP CONTROLFILE TO … TRACE, which generates a SQL script in the trace file to re-create the controlfile. If your database … controlfile.
Purpose → To create a schema for the recovery catalog. Typically, you create this schema in a separate … Recovery Advanced User's Guide to learn how to create the recovery catalog
Restrictions on List Subpartitioning → In addition to the restrictions for composite partitioning in general (see composite_partitioning ), for list subpartitioning: You can specify only one subpartitioning key column. You must specify the list_values_clause, which is subject to the same requirements as at the table level. In the subpartition_template, you cannot specify the hash_subpartition_quantity clause. partition_level_subpartition
Notes on Composite Partitions → and if you have created a subpartition template, then the database uses the template to create … CREATE TABLE statement, NOCACHE is the default In an ALTER TABLE statement, the existing value is not
Restrictions and Usage Notes → Note the following restrictions: Execute CREATE SCRIPT only at the RMAN prompt, not within a RUN … the catalog database must be open. You cannot run CREATE SCRIPT once to create a local script, and … then use this same script on multiple target databases. If you want to create a global script, you … must connect
Restrictions on the ON Clause If you specify the ON clause, you cannot specify the FROM clause. You… → the ON statement. The outline is called salaries and is stored in the category special. CREATE … my_salaries based on the public category salaries created in the preceding example. In order to create a … DBMS_OUTLN_EDIT.CREATE_EDIT_TABLES; CREATE OR REPLACE PRIVATE OUTLINE my_salaries FROM salaries … ) a private outline to the
Restrictions on the Defining Query of a Table → … You cannot define a foreign key constraint in a CREATE TABLE statement that contains AS subquery … . Instead, you must create the table without the constraint and then add it later with an ALTER TABLE … statement. object_table The OF clause lets you explicitly create an object table of type object_type … pseudocolumn
Restrictions on Static Methods → include the declaration of the procedure or function, then you must issue a corresponding CREATE TYPE BODY … Reference for information about method invocation and methods CREATE PROCEDURE and CREATE FUNCTION … for the full syntax with all possible clauses CREATE TYPE BODY "Restrictions on User-Defined … return_clause