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 RECORD


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


Utilities, 9i Release 2 (9.2.0.2)

SQL*Loader Concepts

Variable Record FormatA file is in variable record format when the length of each record in a character field is included … at the beginning of each record in the datafile. This format provides some added flexibility over … the fixed record format and a performance advantage over the stream record format. For example, you

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

What Is a Record?A record is a group of related data items stored in fields, each with its own name and datatype … logically related but dissimilar in type. A record containing a field for each item lets you treat … attribute %ROWTYPE lets you declare a record that represents a row in a database table. However, you … cannot specify the datatypes

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

connection Record TypeThis is a PL/SQL record type used to represent an SMTP connection.

Utilities, 9i Release 2 (9.2.0.2)

SQL*Loader Concepts

Fixed Record FormatA file is in fixed record format when all records in a datafile are the same byte length. Although … specifies that SQL*Loader should interpret the particular datafile as being in fixed record format where … every record is n bytes long. Example 3-1 shows a control file that specifies a datafile that should … be interpreted in

Utilities, 9i Release 2 (9.2.0.2)

SQL*Loader Concepts

Stream Record FormatA file is in stream record format when the records are not specified by size; instead SQL*Loader … forms records by scanning for the record terminator. Stream record format is the most flexible format … interpreted as being in stream record format looks similar to the following: INFILE datafile_name ["str … datafile.

Objects for OLE, 9i Release 2 (9.2.0.2)

Record Count Example for OraSQLStmt

Record Count Example (OraSQLStmt)Feedback Record Count Example (OraSQLStmt) The following example shows the number of records inserted

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

UTL_SMTP, 2 of 3

reply, replies Record TypesThese are PL/SQL record types used to represent an SMTP reply line. Each SMTP reply line consists

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 1 of 6

108 Logical Change Record TypesThis chapter describes the logical change record (LCR) types. In Streams, LCRs are message payloads

Utilities, 9i Release 2 (9.2.0.2)

SQL*Loader Control File Reference

Distinguishing Different Input Record Formatswhich emp and dept records are intermixed: 1 50 Manufacturing -- DEPT record 2 1119 Smith 50 -- EMP … record 2 1120 Snyder 50 1 60 Shipping 2 1121 Stevens 60 A record ID field distinguishes between the

Administrator's Guide, 9i Release 2 (9.2.0.2)

Managing Distributed Transactions

Step 1: Record User Feedbackrequest and record this ID number from users that report problems to identify which in-doubt transactions should be forced.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Collections and Records

Restrictions on Record Inserts/UpdatesCurrently, the following restrictions apply to record inserts/updates: Record variables are allowed … VALUES clause of an INSERT statement In the INTO subclause of a RETURNING clause Record variables are … statement contains a record variable, no other variable or value is allowed in the clause. If the INTO

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 3 of 6

EXECUTE Member ProcedureExecutes the row LCR under the security domain of the current user. Any apply process handlers that would be run for an LCR are not run when the LCR is applied using this procedure. Note: The EXECUTE member procedure can be invoked only in an apply handler for an apply process. Syntax MEMBER PROCEDURE EXECUTE( conflict_resolution IN BOOLEAN); Parameters Table 108-14 EXECUTE Procedure Parameters Parameter

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 4 of 6

GET_TRANSACTION_ID Member FunctionReturns the transaction identifier of the LCR. Syntax MEMBER FUNCTION GET_TRANSACTION_ID RETURN VARCHAR2;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 2 of 6

SET_LOGON_USER Member ProcedureSets the logon user name. Syntax MEMBER PROCEDURE SET_LOGON_USER( logon_user IN VARCHAR2); Parameter Table 108-8 SET_LOGON_USER Procedure Parameter Parameter Description logon_user The name of the schema to set as the logon user

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 4 of 6

Common Subprograms for LCR$_ROW_RECORD and LCR$_DDL_RECORDThe following functions and procedures are common to both the LCR$_ROW_RECORD and LCR$_DDL_RECORD type. See Also: For descriptions of the subprograms for these types that are exclusive to each type: "Summary of LCR$_DDL_RECORD Subprograms" "Summary of LCR$_ROW_RECORD Subprograms" Table 108-26 Summary of Common Subprograms for Row and DDL Types  Subprogram Description "GET_COMMAND_TYPE Member Function"

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 2 of 6

GET_BASE_TABLE_NAME Member FunctionReturns the base (dependent) table name. Syntax MEMBER FUNCTION GET_BASE_TABLE_NAME RETURN VARCHAR2;

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 4 of 6

SET_COMMAND_TYPE Member ProcedureSets the command type. If the command type specified cannot be interpreted, then an error is raised. For example, changing INSERT to GRANT would raise an error. See Also: The description of the command_type parameter in "LCR$_DDL_RECORD Constructor Function Parameters" The description of the command_type parameter in "LCR$_ROW_RECORD Constructor Function Parameters" The "SQL Command Codes" table in

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 3 of 6

LCR$_ROW_RECORD ConstructorCreates a SYS.LCR$_ROW_RECORD object with the specified information. STATIC FUNCTION CONSTRUCT( source_database_name IN VARCHAR2, command_type IN VARCHAR2, object_owner IN VARCHAR2, object_name IN VARCHAR2, tag IN RAW DEFAULT NULL, transaction_id IN VARCHAR2 DEFAULT NULL, scn IN NUMBER DEFAULT NULL, old_values IN SYS.LCR$_ROW_LIST DEFAULT NULL, new_values IN SYS.LCR$_ROW_LIST DEFAULT NULL) RETURN

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 5 of 6

SyntaxCREATE TYPE SYS.LCR$_ROW_LIST AS TABLE OF SYS.LCR$_ROW_UNIT / Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Logical Change Record Types, 3 of 6

Summary of LCR$_ROW_RECORD SubprogramsTable 108-11 LCR$_ROW_RECORD Subprograms (Page 1 of 2) Subprogram Description Common Subprograms See "Common Subprograms for LCR$_ROW_RECORD and LCR$_DDL_RECORD" for a list of subprograms common to the SYS.LCR$_ROW_RECORD and SYS.LCR$_DDL_RECORD types "ADD_COLUMN Member Procedure" Adds the value as old or new, depending on the value type specified, for the column "DELETE_COLUMN Member Procedure" Deletes