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 ROWTYPE


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


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

PL/SQL Language Elements, 43 of 52

%ROWTYPE AttributeThe %ROWTYPE attribute provides a record type that represents a row in a database table. The record … use the %ROWTYPE attribute in variable declarations as a datatype specifier. Variables declared using … %ROWTYPE are treated like those declared using a datatype name. For more information, see "Using %ROWTYPE".

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

PL/SQL Language Elements, 1 of 52

%ROWTYPE AttributeSAVEPOINT Statement

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

Fundamentals of PL/SQL

Using %ROWTYPEThe %ROWTYPE attribute provides a record type that represents a row in a table (or view). The … %ROWTYPE; CURSOR c1 IS SELECT deptno, dname, loc FROM dept; dept_rec c1%ROWTYPE; Columns in a row and … corresponding fields in a record have the same names and datatypes. However, fields in a %ROWTYPE … := 'JOHNSON';

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00310 with %ROWTYPE attribute, ' string ' must name a table, cursor or cursor-variableCause: The %ROWTYPE attribute must be applied to an identifier declared as a cursor, cursor … variable, or database table. This error occurs when %ROWTYPE follows some identifier that has not been so … declared. Action: Change the declaration or do not apply the %ROWTYPE attribute to the identifier.

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

PL/SQL Language Elements, 43 of 52

ExamplesIn the example below, you use %ROWTYPE to declare two records. The first record stores a row … emp%ROWTYPE; CURSOR c1 IS SELECT deptno, dname, loc FROM dept; dept_rec c1%ROWTYPE; In the next … example, you select a row from the emp table into a %ROWTYPE record: DECLARE emp_rec emp%ROWTYPE

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

Interaction Between PL/SQL and Oracle

Cursor Variable Example: Client-Side PL/SQL Blockretrieved information: DECLARE lib_cv cv_types.LibCurTyp; book_rec books%ROWTYPE; periodical_rec … periodicals%ROWTYPE; tape_rec tapes%ROWTYPE; BEGIN get_title(:title); -- title is a host variable

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

PL/SQL Language Elements, 29 of 52

Related TopicsCursors, EXIT Statement, FETCH Statement, OPEN Statement, %ROWTYPE Attribute Copyright © 1996, 2002

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

PL/SQL Language Elements, 11 of 52

Related Topics"Declarations", "Predefined Datatypes", Assignment Statement, Expressions, %ROWTYPE Attribute

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

PL/SQL Language Elements, 51 of 52

Related TopicsConstants and Variables, %ROWTYPE Attribute Copyright © 1996, 2002 Oracle Corporation. All Rights

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

PL/SQL Language Elements, 45 of 52

Related TopicsAssignment Statement, FETCH Statement, %ROWTYPE Attribute Copyright © 1996, 2002 Oracle Corporation

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

PL/SQL Collections and Records

Inserting PL/SQL Records into the Databasesingle variable of type RECORD or %ROWTYPE instead of a list of fields. That makes your code more … as the type table_name %ROWTYPE. Inserting a PL/SQL Record Using %ROWTYPE: Example This example … declares a record variable using a %ROWTYPE qualifier. You can insert this variable without specifying … a column

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

Interaction Between PL/SQL and Oracle

Declaring Cursor VariablesDeptCurTyp IS REF CURSOR RETURN dept%ROWTYPE; dept_cv DeptCurTyp; -- declare cursor variable Note: You … %ROWTYPE to specify a record type that represents a row returned by a strongly (not weakly) typed cursor … variable, as follows: DECLARE TYPE TmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE; tmp_cv TmpCurTyp … ; -- declare cursor

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

PL/SQL Language Elements, 2 of 52

Usage Notes: DECLARE emp_rec emp%ROWTYPE; BEGIN... emp_rec.sal:= current_salary + increase; Moreover, you can … is legal: DECLARE emp_rec1 emp%ROWTYPE; emp_rec2 emp%ROWTYPE; dept_rec dept%ROWTYPE; BEGIN

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

PL/SQL Language Elements, 14 of 52

ExamplesWHERE sal > 2000; CURSOR c2 RETURN dept%ROWTYPE IS SELECT * FROM dept WHERE deptno = 10; CURSOR c3

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Coding Dynamic SQL Statements

Using PL/SQL Records in SQL INSERT and UPDATE Statements%ROWTYPE attribute, so that it has exactly the same fields as the SQL table. DECLARE emp_rec emp%ROWTYPE … ; BEGIN emp_rec.eno:= 1500; emp_rec.ename:= 'Steven Hill'; emp_rec.sal:= '40000'; -- A %ROWTYPE … value can fill in all the row fields. INSERT INTO emp VALUES emp_rec; -- The fields of a %ROWTYPE can

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

Interaction Between PL/SQL and Oracle

Separating Cursor Specs and Bodies with Packages]...)] RETURN return_type; In the following example, you use the %ROWTYPE attribute to provide a record type … %ROWTYPE; -- declare cursor spec... END emp_stuff; CREATE PACKAGE BODY emp_stuff AS CURSOR c1 RETURN … emp%ROWTYPE IS SELECT * FROM emp WHERE sal > 2500; -- define cursor body... END emp_stuff; The cursor … RETURN emp%ROWTYPE

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Using Procedures and Packages

Examples of Cursor VariablesEmp_val_cv_type IS REF CURSOR RETURN Emp_tab%ROWTYPE; PROCEDURE Open_emp_cv (Emp_cv IN OUT … Emp_tab%ROWTYPE); END Emp_data; CREATE OR REPLACE PACKAGE BODY Emp_data AS PROCEDURE Open_emp_cv … , Emp_row OUT Emp_tab%ROWTYPE) IS BEGIN FETCH Emp_cv INTO Emp_row; END Fetch_emp_data; END Emp_data; The … ; Emp_row Emp_tab%ROWTYPE;

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

Overview of PL/SQL

Attributesstring for example), the datatype of my_title changes accordingly at run time. %ROWTYPE In PL/SQL … can be stored. The %ROWTYPE attribute provides a record type that represents a row in a table. The … as the columns in the dept table. DECLARE dept_rec dept%ROWTYPE; -- declare record variable You use … , you can use %ROWTYPE

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

PL/SQL Language Elements, 43 of 52

Usage NotesThe %ROWTYPE attribute lets you declare records structured like a row of data in a database table … they were declared. Select-items fetched from a cursor associated with %ROWTYPE must have simple names or, if they are expressions, must have aliases.

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

PL/SQL Language Elements, 51 of 52

Keyword and Parameter Description) previously declared within the current scope. record_name This identifies a user-defined or %ROWTYPE … a user-defined or %ROWTYPE record previously declared within the current scope. variable_name This