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
context-name → A 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
ROW function → The 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
INSTANTIATE_ONLINE Function → This 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
Parameters → Table 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
Returns → Table 20-8 INSTANTIATE_ONLINE Function Returns Return Value Description Specifies the generated
Syntax → DBMS_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;
Parameters → Table 21-33 CREATE_USER_PARM_VALUE Function Parameters Parameter Description
Returns → Table 21-20 CREATE_OBJECT_FROM_EXISTING Function Returns Return Value Description System-generated number used internally by Oracle.
Parameters → Table 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.
INSTANTIATE_ONLINE Function → This 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
CREATE_TEMPLATE_OBJECT Function → This 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.
Syntax → DBMS_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;
Exceptions → Table 20-4 INSTANTIATE_OFFLINE Function Exceptions Exception Description miss_refresh_template The
Parameters → Table 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
Returns → Table 21-65 INSTANTIATE_OFFLINE Function Returns Return Value Description Specifies the generated
CREATE FUNCTION → Purpose 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
Restrictions on User-Defined Functions → statement 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
SQLCODE Function → The 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".
Parameters → None