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 FUNCTION


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


DML Reference, 10g Release 1 (10.1)

CONTEXT function

context-nameA text expression that contains the name of the context. Using the CONTEXT function with only the … context. UPDATE When you specify UPDATE with the CONTEXT function, the return value is the number of … saved in the context. When you specify name with the CONTEXT function, the return value is the … 9-17 Listing Context Names In

DML Reference, 10g Release 1 (10.1)

ROW function

ROW functionThe ROW function returns a line of data in cells, one after another in a single row. It is … current outfile. The ROW function, just like the ROW command, consists of a series of column descriptions … ROW function lets you assign the returned value to a text variable, send it to your current outfile … command for a complete description

Advanced Replication Management API Reference, 10g Release 1 (10.1)

INSTANTIATE_ONLINE Function

INSTANTIATE_ONLINE FunctionThis function generates a script at the master site that is used to create the materialized view … generated by this function is stored in the USER_REPCAT_TEMP_OUTPUT temporary view and is used by several … templates. The number returned by this function is used to retrieve the appropriate information from the … USER_REPCAT_TEMP_OUTPUT

Advanced Replication Management API Reference, 10g Release 1 (10.1)

INSTANTIATE_ONLINE Function

ParametersTable 20-6 INSTANTIATE_ONLINE Function Parameters Parameter Description refresh_template_name The … parameters (the identification was retrieved by using the GET_RUNTIME_PARM_ID function). next_date

Advanced Replication Management API Reference, 10g Release 1 (10.1)

INSTANTIATE_ONLINE Function

ReturnsTable 20-8 INSTANTIATE_ONLINE Function Returns Return Value Description Specifies the generated

Advanced Replication Management API Reference, 10g Release 1 (10.1)

COPY_TEMPLATE Function

SyntaxDBMS_REPCAT_RGT.COPY_TEMPLATE ( old_refresh_template_name IN VARCHAR2, new_refresh_template_name IN VARCHAR2, copy_user_authorizations IN VARCHAR2, dblink IN VARCHAR2:= NULL) return NUMBER;

Advanced Replication Management API Reference, 10g Release 1 (10.1)

CREATE_USER_PARM_VALUE Function

ParametersTable 21-33 CREATE_USER_PARM_VALUE Function Parameters   Parameter Description

Advanced Replication Management API Reference, 10g Release 1 (10.1)

CREATE_OBJECT_FROM_EXISTING Function

ReturnsTable 21-20 CREATE_OBJECT_FROM_EXISTING Function Returns Return Value Description System-generated number used internally by Oracle.

Advanced Replication Management API Reference, 10g Release 1 (10.1)

PURGE Function

ParametersTable 14-18 PURGE Function Parameters   Parameter Description purge_method Controls how to purge … function in the server's trace file. When set to false, Oracle does not record the result value.

Advanced Replication Management API Reference, 10g Release 1 (10.1)

INSTANTIATE_ONLINE Function

INSTANTIATE_ONLINE FunctionThis function generates a script at the master site that is used to create the materialized view … (depending on the amount of data that is populated to the new materialized views). This function must … be executed separately for each user instantiation. The script generated by this function is stored … Replication Manager, during

Advanced Replication Management API Reference, 10g Release 1 (10.1)

CREATE_TEMPLATE_OBJECT Function

CREATE_TEMPLATE_OBJECT FunctionThis function adds object definitions to a target deployment template container. The specified … view site. In addition to adding materialized views, this function can add tables, procedures, and … other objects to your template. The number returned by this function is used internally by Oracle to manage deployment templates.

Advanced Replication Management API Reference, 10g Release 1 (10.1)

INSTANTIATE_OFFLINE Function

SyntaxDBMS_REPCAT_INSTANTIATE.INSTANTIATE_OFFLINE( refresh_template_name IN VARCHAR2, site_name IN VARCHAR2, runtime_parm_id IN NUMBER:= -1e-130, next_date IN DATE:= SYSDATE, interval IN VARCHAR2:= 'SYSDATE + 1', use_default_gowner IN BOOLEAN:= true) return NUMBER;

Advanced Replication Management API Reference, 10g Release 1 (10.1)

INSTANTIATE_OFFLINE Function

ExceptionsTable 20-4 INSTANTIATE_OFFLINE Function Exceptions Exception Description miss_refresh_template The

Advanced Replication Management API Reference, 10g Release 1 (10.1)

INSTANTIATE_OFFLINE Function

ParametersTable 21-63 INSTANTIATE_OFFLINE Function Parameters   Parameter Description refresh_template_name … identification was retrieved by using the GET_RUNTIME_PARM_ID function). next_date Specifies the next

Advanced Replication Management API Reference, 10g Release 1 (10.1)

INSTANTIATE_OFFLINE Function

ReturnsTable 21-65 INSTANTIATE_OFFLINE Function Returns Return Value Description Specifies the generated

SQL Reference, 10g Release 1 (10.1)

CREATE FUNCTION

CREATE FUNCTIONPurpose Use the CREATE FUNCTION statement to create a standalone stored function or a call … specification. A stored function (also called a user function or user defined function ) is a set of PL/SQL … function returns a value to the environment in which it is called. User functions

SQL Reference, 10g Release 1 (10.1)

CREATE FUNCTION

Restrictions on User-Defined Functionsstatement In a DEFAULT clause of a CREATE TABLE or ALTER TABLE statement In addition, when a function … is called from within a query or DML statement, the function cannot: Have OUT or IN OUT parameters … -defined function cannot execute any DDL statements. Write to the database, if the function is being … called

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

SQLCODE Function

SQLCODE FunctionThe function SQLCODE returns the number code of the most recent exception. For internal exceptions … purity of a stored function, you cannot specify the constraints WNPS and RNPS if the function calls … Function, "Retrieving the Error Code and Error Message: SQLCODE and SQLERRM".

Advanced Replication Management API Reference, 10g Release 1 (10.1)

GLOBAL_NAME Function

ParametersNone

Advanced Replication Management API Reference, 10g Release 1 (10.1)

CREATE_TEMPLATE_PARM Function

ExceptionsTable 21-28 CREATE_TEMPLATE_PARM Function Exceptions   Exception Description miss_refresh_template