Results for RECORD


1 to 20 of 1449 results. Prev  Next
Results per page:   20  | 40 | 60


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

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

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)

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

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

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

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 … 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.

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

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

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

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

Logical Change Record Types, 2 of 6

LCR$_DDL_RECORD TypeThis type represents a DDL change to a database object. If you create or modify a DDL LCR, then make sure the ddl_text is consistent with the base_table_name, base_table_owner, object_type, object_owner, object_name, and command_type attributes. Note: When passing a name as a parameter to an LCR constructor, you can enclose the name in double quotes to handle names that use mixed case or lower case

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

Logical Change Record Types, 2 of 6

Summary of LCR$_DDL_RECORD SubprogramsTable 108-2 LCR$_DDL_RECORD Subprograms  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 \"EXECUTE Member Procedure\" Executes the LCR under the security domain of the current user \"GET_BASE_TABLE_NAME Member Function\" Returns the base (dependent)

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

Logical Change Record Types, 2 of 6

SET_BASE_TABLE_NAME Member ProcedureSets the base (dependent) table name. Syntax MEMBER PROCEDURE SET_BASE_TABLE_NAME( base_table_name IN VARCHAR2); Parameter Table 108-4 SET_BASE_TABLE_NAME Procedure Parameter Parameter Description base_table_name The name of the base table

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

Logical Change Record Types, 2 of 6

SET_BASE_TABLE_OWNER Member ProcedureSets the base (dependent) table owner. Syntax MEMBER PROCEDURE SET_BASE_TABLE_OWNER( base_table_owner IN VARCHAR2); Parameter Table 108-5 SET_BASE_TABLE_OWNER Procedure Parameter Parameter Description base_table_owner The name of the base owner

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

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

Logical Change Record Types, 4 of 6

SET_OBJECT_OWNER Member ProcedureSets the owner of the object that is changed by the LCR. Syntax MEMBER PROCEDURE SET_OBJECT_OWNER( object_owner IN VARCHAR2); Parameter Table 108-29 SET_OBJECT_OWNER Procedure Parameter Parameter Description object_owner The schema that contains the object

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

GET_VALUE Member FunctionReturns the old or new value for the specified column, depending on the value type specified. Syntax MEMBER FUNCTION GET_VALUE( value_type IN VARCHAR2, column_name IN VARCHAR2) RETURN SYS.AnyData; Parameters Table 108-18 GET_VALUE Procedure Parameters Parameter Description value_type The type of value to return for the column. Specify old to get the old value for the column. Specify new to get the

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

Logical Change Record Types, 3 of 6

SET_LOB_OFFSET Member ProcedureSets the LOB offset for the specified column in the number of characters for CLOB columns and the number of bytes for BLOB columns. Syntax SET_LOB_OFFSET( value_type IN VARCHAR2, column_name IN VARCHAR2, lob_offset IN NUMBER); Parameters Table 108-22 SET_LOB_OFFSET Procedure Parameters Parameter Description value_type The type of value to set for the column. Currently, only new can be specified. column_name





Was this page helpful?

Integrated Cloud Applications & Platform Services