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 ALL


1 to 20 of 12625 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Reference, 10g Release 1 (10.1)

Static Methods Common to All Object Types

Static Methods Common to All Object TypesThe examples in this section assume that you have created the test tables as described in Example Audio Table Definition, Example Media Table Definition, Example Image Table Definition, and Example Video Table Definition, respectively for each object type. This section presents reference information on the inter Media common static methods used for the relational interface.

SQL Reference, 10g Release 1 (10.1)

The UNION [ALL], INTERSECT, MINUS Operators

The UNION [ALL], INTERSECT, MINUS OperatorsYou can combine multiple queries using the set operators UNION, UNION ALL, INTERSECT, and MINUS … . All set operators have equal precedence. If a SQL statement contains multiple set operators, then … selects values of type BINARY_FLOAT, then the returned values have datatype BINARY_FLOAT. If allALL Example

Reference, 10g Release 1 (10.1)

Static Methods Common to All Object Types

export( )Format export(ctx IN OUT RAW, local_data IN BLOB, source_type IN VARCHAR2, source_location IN VARCHAR2, source_name IN VARCHAR2); Description Copies data from a local source (local_data) within the database to an external data source. Note: The export( ) method natively supports only sources of source type "file". User-defined sources may also support the export( ) method. Parameters

Reference, 10g Release 1 (10.1)

Static Methods Common to All Object Types

importFrom( ) (all attributes)Format importFrom(ctx IN OUT RAW, local_data IN OUT NOCOPY BLOB, source_type IN VARCHAR2, source_location IN VARCHAR2, source_name IN VARCHAR2, format OUT VARCHAR2, mime_type OUT VARCHAR2); Description Transfers data from the specified external data source to the source.localData attribute (of the embedded ORDSource object type) within the database. Parameters

Reference, 10g Release 1 (10.1)

Static Methods Common to All Object Types

ctxThe source plug-in context information. local_data The BLOB location that is being exported. source_type The type of the source data that is being exported. source_location The location to which the source data is to be exported. source_name The name of the object to where the source data is to be exported. Usage Notes After calling the export( ) method, you can issue a SQL DELETE statement or call

Reference, 10g Release 1 (10.1)

Static Methods Common to All Object Types

importFrom( )Format importFrom(ctx IN OUT RAW, local_data IN OUT NOCOPY BLOB, source_type IN VARCHAR2, source_location IN VARCHAR2, source_name IN VARCHAR2); Description Transfers data from the specified external data source to the source.localData attribute (of the embedded ORDSource object type) within the database. Parameters

Reference, 10g Release 1 (10.1)

Static Methods Common to All Object Types

ctxThe source plug-in context information. This should be allocated and initialized to NULL. If you are using a user-defined source plug-in, you should call the openSource( ) method. See the introduction to this chapter for more information. local_data The BLOB location to receive the data. source_type The type of the source data. source_location The location from which the source data is to be imported.

Reference, 10g Release 1 (10.1)

Static Methods Common to All Object Types

ctxThe source plug-in context information. local_data The BLOB location to receive the data. source_type The type of the source data. source_location The location from which the source data is to be imported. source_name The name of the source data. format The format of the data. The value is returned if it is available (from HTTP sources). mime_type The MIME type of the data. The value is returned if

DML Reference, 10g Release 1 (10.1)

TRIGGER command

DELETE ALLDeletes all of the triggers for the specified object. Oracle OLAP disassociates the trigger program … from all events for object. Notes Multiple Occurrences of the Same Keyword You can use all of the … required name No No MAINTAIN DELETE ( not ALL) No required name Yes No MAINTAIN DELETE ALL No required

Oracle® Net Services Reference Guide, 10g Release 1 (10.1)

2 Oracle Connection Manager Control Utility

SHOW ALLPurpose Use the SHOW ALL command to combine and display output from the SHOW PARAMETERS and SHOW … system: cmctl SHOW ALL {-c instance_name} {-p password} From the Oracle Connection Manager Control … utility: CMCTL> SHOW ALL Example CMCTL:CMAN_user-sun.us.oracle.com> SHOW ALL listener_address | (address

Advanced Queuing User's Guide and Reference, 10g Release 1 (10.1)

9 Oracle Streams AQ Administrative Interface: Views

All Propagation Schedules ViewName of View DBA_QUEUE_SCHEDULES Purpose Describes the current schedules for propagating messages. Table 9-4 DBA_QUEUE_SCHEDULES View Column Datatype NULL Description SCHEMA VARCHAR2(30) NOT NULL Schema name for the source queue QNAME VARCHAR2(30) NOT NULL Source queue name DESTINATION VARCHAR2(128) NOT NULL Destination name, currently limited to be a database link name START_DATE DATE - Date to start

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

16 Large Objects (LOBs)

16.4.9 FILE CLOSE ALLPurpose Closes all BFILES opened in the current session. Syntax EXEC SQL [AT [:]database] LOB FILE … CLOSE ALL. Usage Notes If there are any open files in the session whose closure has not been handled … properly, you can use the FILE CLOSE ALL statement to close all files opened in the session, and resume file operations

Advanced Queuing User's Guide and Reference, 10g Release 1 (10.1)

9 Oracle Streams AQ Administrative Interface: Views

All Transformations ViewName of View DBA_TRANSFORMATIONS Purpose Displays all the transformations in the database. These

Advanced Queuing User's Guide and Reference, 10g Release 1 (10.1)

9 Oracle Streams AQ Administrative Interface: Views

All Transformation Functions ViewName of View DBA_ATTRIBUTE_TRANSFORMATIONS Purpose Displays the transformation functions for all

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

13 Large Objects (LOBs)

13.4.9 FILE CLOSE ALLPurpose Closes all BFILES opened in the current session. Syntax EXEC SQL [AT [:]database] LOB FILE … CLOSE ALL END-EXEC. Usage Notes If there are any open files in the session whose closure has not … been handled properly, you can use the FILE CLOSE ALL statement to close all files opened in the session and resume file

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

17 Objects

17.4.4 CACHE FREE ALLEXEC SQL [AT [:]database] [OBJECT] CACHE FREE ALL; Use the earlier statement to free all object … cache memory for the specified database connection. See Also: "CACHE FREE ALL (Executable Embedded SQL Extension)"

Security Guide, 10g Release 1 (10.1)

10 Administe ring User Privileges, Roles, and Profiles

Listing All Tablespace QuotasThe following query lists all tablespace quotas specifically assigned to each user: SELECT * FROM

Utilities, 10g Release 1 (10.1)

9 Field List Reference

Loading All-Blank Fields, use the NULLIF clause with the BLANKS parameter. If an all-blank CHAR field is surrounded by … : Case Study 6: Loading Data Using the Direct Path Load Method for an example of how to load all-blank

Security Guide, 10g Release 1 (10.1)

10 Administe ring User Privileges, Roles, and Profiles

Listing All Role GrantsThe following query returns all the roles granted to users and other roles: SELECT * FROM

Concepts and Administration, 10g Release 1 (10.1)

14 Monitoring a Streams Environment

Displaying All Rules Used by All Streams Clientsdictionary views to display all rules in the rule sets for Streams clients, including Streams rules … been modified. The query in this section displays the following information about all of the rules