Results for RECORD


1 to 40 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

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

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

Logical Change Record Types, 6 of 6

SyntaxCREATE TYPE LCR$_ROW_UNIT AS OBJECT ( column_name VARCHAR2(4000), data SYS.AnyData, lob_information NUMBER, lob_offset NUMBER, lob_operation_size NUMBER); /

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

Logical Change Record Types, 6 of 6

AttributesTable 108-32 LCR$_ROW_UNIT Attributes Attribute Description column_name The name of the column data The data contained in the column lob_information Contains the LOB information for the column and contains one of the following values: DBMS_LCR.NOT_A_LOB CONSTANT NUMBER:= 1; DBMS_LCR.NULL_LOB CONSTANT NUMBER:= 2; DBMS_LCR.INLINE_LOB CONSTANT NUMBER:= 3; DBMS_LCR.EMPTY_LOB CONSTANT NUMBER:= 4; DBMS_LCR.LOB_CHUNK

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

Logical Change Record Types, 2 of 6

EXECUTE Member ProcedureExecutes the DDL 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();

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

Logical Change Record Types, 2 of 6

GET_CURRENT_SCHEMA Member FunctionReturns the current schema name. Syntax MEMBER FUNCTION GET_CURRENT_SCHEMA RETURN VARCHAR2;

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

Logical Change Record Types, 3 of 6

DELETE_COLUMN Member ProcedureDeletes the old value, the new value, or both, for the specified column, depending on the value type specified. Syntax MEMBER PROCEDURE DELETE_COLUMN( column_name IN VARCHAR2, value_type IN VARCHAR2 DEFAULT '*'); Parameters Table 108-13 DELETE_COLUMN Procedure Parameters Parameter Description column_name The column name. An error is raised if the column does not exist in the LCR. value_type The type

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

Logical Change Record Types, 3 of 6

GET_LOB_INFORMATION Member FunctionGets the LOB information for the column. The return value can be one of the following: DBMS_LCR.NOT_A_LOB CONSTANT NUMBER:= 1; DBMS_LCR.NULL_LOB CONSTANT NUMBER:= 2; DBMS_LCR.INLINE_LOB CONSTANT NUMBER:= 3; DBMS_LCR.EMPTY_LOB CONSTANT NUMBER:= 4; DBMS_LCR.LOB_CHUNK CONSTANT NUMBER:= 5; DBMS_LCR.LAST_LOB_CHUNK CONSTANT NUMBER:= 6; Returns NULL if the specified column does not exist. Syntax MEMBER FUNCTION

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

Logical Change Record Types, 3 of 6

GET_VALUES Member FunctionReturns a list of old or new values, depending on the value type specified. Syntax MEMBER FUNCTION GET_VALUES( value_type IN VARCHAR2) RETURN SYS.LCR$_ROW_LIST; Parameter Table 108-19 GET_VALUES Procedure Parameter Parameter Description value_type The type of values to return. Specify old to return a list of old values. Specify new to return a list of new values.

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

Logical Change Record Types, 3 of 6

SET_VALUE Member ProcedureOverwrites the old or new value of the specified column. One reason you may want to overwrite an old value for a column is to resolve an error that resulted from a conflict. Syntax MEMBER PROCEDURE SET_VALUE( value_type IN VARCHAR2, column_name IN VARCHAR2, column_value IN SYS.AnyData); Parameters Table 108-24 SET_VALUE Procedure Parameters Parameter Description value_type The type of value to set.

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, 2 of 6

GET_BASE_TABLE_OWNER Member FunctionReturns the base (dependent) table owner. Syntax MEMBER FUNCTION GET_BASE_TABLE_OWNER RETURN VARCHAR2;

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

Logical Change Record Types, 3 of 6

LCR$_ROW_RECORD Constructor Function Parameterschange record was written to the redo old_values If the DML statement is an UPDATE or a DELETE

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

Logical Change Record Types, 4 of 6

GET_OBJECT_OWNER Member FunctionReturns the owner of the object that is changed by the LCR. Syntax MEMBER FUNCTION GET_OBJECT_OWNER RETURN VARCHAR2;

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

Logical Change Record Types, 4 of 6

IS_NULL_TAG Member FunctionReturns Y if the tag for the LCR is NULL, or returns N if the tag for the LCR is not NULL. See Also: Oracle9i Streams for more information about tags Syntax MEMBER FUNCTION IS_NULL_TAG RETURN VARCHAR2;

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

Logical Change Record Types, 6 of 6

LCR$_ROW_UNIT TypeIdentifies the value for a column in a row. This type is used in the LCR$_ROW_LIST type. See Also: \"LCR$_ROW_LIST Type\"

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

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, 3 of 6

LCR$_ROW_RECORD TypeThis type represents a DML change to a row in a table. This type uses the LCR$_ROW_LIST type. If you create or modify a row LCR, then make sure the command_type attribute is consistent with the presence or absence of old column values and the presence or absence of new column values. Note: When passing a name as a parameter to an LCR constructor, you can enclose the name in double quotes to handle

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

Logical Change Record Types, 3 of 6

GET_LOB_OPERATION_SIZE Member FunctionGets the operation size for the LOB column in the number of characters for CLOB columns and the number of bytes for BLOB columns. Returns a non- NULL value only if all of the following conditions are met: The value exists for the column The column value is an out-of-line LOB The command type is LOB ERASE or LOB TRIM The information is DBMS_LCR.LAST_LOB_CHUNK Otherwise, returns NULL. Syntax MEMBER

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

Logical Change Record Types, 3 of 6

SET_LOB_OPERATION_SIZE Member ProcedureSets the operation size for the LOB column in the number of characters for CLOB columns and bytes for BLOB columns. Syntax MEMBER PROCEDURE SET_LOB_OPERATION_SIZE( value_type IN VARCHAR2, column_name IN VARCHAR2, lob_operation_size IN NUMBER); Parameters Table 108-23 SET_LOB_OPERATION_SIZE Procedure Parameters Parameter Description value_type The type of value to set for the column. Currently, only





Was this page helpful?

Integrated Cloud Applications & Platform Services