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 103 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


User's Guide and Reference, 10g Release 1 (10.1)

%ROWTYPE Attribute

%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 … the %ROWTYPE

User's Guide and Reference, 10g Release 1 (10.1)

2 Fundamentals of the PL/SQL Language

Using the %ROWTYPE AttributeThe %ROWTYPE attribute provides a record type that represents a row in a table (or view). The … typed cursor variable: DECLARE -- %ROWTYPE can include all the columns in a table... emp_rec employees … %ROWTYPE; --...or a subset of the columns, based on a cursor. CURSOR c1 IS SELECT department_id … , department_name FROM departments;

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-00310: with %%ROWTYPE attribute, ' string ' must name a table, cursor or cursor-variablesome identifier that has not been so declared. Action: none PLS-00310: with %%ROWTYPE attribute, ' string ' must name a table, cursor or cursor-variable

User's Guide and Reference, 10g Release 1 (10.1)

5 Using PL/SQL Collections and Records

Inserting PL/SQL Records into the Databasesingle variable of type RECORD or %ROWTYPE in the VALUES clause instead of a list of fields. That … most convenient to declare the variable as the type table_name %ROWTYPE. Example 5-34 Inserting a PL … /SQL Record Using %ROWTYPE This example declares a record variable using a %ROWTYPE qualifier. You can … insert

User's Guide and Reference, 10g Release 1 (10.1)

6 Performing SQL Operations from PL/SQL

Using PL/SQL Records in SQL INSERT and UPDATE Statements/SQL records directly. The most convenient technique is to declare the record using a %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.

User's Guide and Reference, 10g Release 1 (10.1)

6 Performing SQL Operations from PL/SQL

Declaring REF CURSOR Types and Cursor VariablesTYPE DeptCurTyp IS REF CURSOR RETURN departments%ROWTYPE; REF CURSOR types can be strong (with a … type in any PL/SQL block or subprogram. DECLARE TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE … variable dept_cv: DECLARE TYPE DeptCurTyp IS REF CURSOR RETURN dept%ROWTYPE; dept_cv DeptCurTyp … Cursor Variable Returning %ROWTYPE

User's Guide and Reference, 10g Release 1 (10.1)

1 Overview of PL/SQL

Declaring PL/SQL Variablesand %ROWTYPE to declare variables that hold table columns or table rows. %TYPE The %TYPE attribute … my_title changes accordingly at run time. %ROWTYPE In PL/SQL, records are used to group data. A … record consists of a number of related fields in which data values can be stored. The %ROWTYPE … . DECLARE dept_rec dept%ROWTYPE;

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

7 Using Procedures and Packages

Examples of Cursor VariablesIS REF CURSOR RETURN Emp_tab%ROWTYPE; PROCEDURE Open_emp_cv (Emp_cv IN OUT Emp_val_cv_type … , Dept_number IN INTEGER); PROCEDURE Fetch_emp_data (emp_cv IN Emp_val_cv_type, emp_row OUT Emp_tab%ROWTYPE … %ROWTYPE) IS BEGIN FETCH Emp_cv INTO Emp_row; END Fetch_emp_data; END Emp_data; The following example … variable Emp_curs Emp_data.Emp_val_cv_type;

User's Guide and Reference, 10g Release 1 (10.1)

5 Using PL/SQL Collections and Records

What Is a PL/SQL Record?… The fields correspond to table columns. The %ROWTYPE attribute lets you declare a record that … any necessary joins, and then apply %ROWTYPE to the view or cursor.

User's Guide and Reference, 10g Release 1 (10.1)

9 Using PL/SQL Packages

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 … to reference

User's Guide and Reference, 10g Release 1 (10.1)

5 Using PL/SQL Collections and Records

Defining and Declaring Recordsor find a table, view, or PL/SQL cursor with the values you want, and use the %ROWTYPE attribute to … in this case. rec3 employees%ROWTYPE; -- Or we can mix fields that are table columns with user … hold information about a department: DECLARE -- Best: use %ROWTYPE instead of specifying each column … . -- Using %ROWTYPE

User's Guide and Reference, 10g Release 1 (10.1)

6 Performing SQL Operations from PL/SQL

Defining Aliases for Expression Values in a Cursor FOR LoopIn a cursor FOR loop, PL/SQL creates a %ROWTYPE record with fields corresponding to columns in the

User's Guide and Reference, 10g Release 1 (10.1)

6 Performing SQL Operations from PL/SQL

Looping Through Multiple Rows: Cursor FOR Loop%ROWTYPE record whose field names match the column names from the query, and that exists only during

User's Guide and Reference, 10g Release 1 (10.1)

Constants and Variables

Constants and Variablescurrent scope. record_name A user-defined or %ROWTYPE record previously declared within the current … scope. record_name.field_name A field in a user-defined or %ROWTYPE record previously declared … datatype specifier REF CURSOR. %ROWTYPE Represents a record that can hold a row from a database table or a … use %ROWTYPE

User's Guide and Reference, 10g Release 1 (10.1)

5 Using PL/SQL Collections and Records

Declaring PL/SQL Collection VariablesSpecifying Collection Element Types with %TYPE and %ROWTYPE To specify the element type, you can use … %TYPE, which provides the datatype of a variable or database column. Also, you can use %ROWTYPE … , which provides the rowtype of a cursor or database table. Two examples follow: DECLARE -- Nested table … . TYPE Top_Salespeople

User's Guide and Reference, 10g Release 1 (10.1)

%TYPE Attribute

%TYPE Attributescope. record_name A user-defined or %ROWTYPE record, previously declared within the current scope … . record_name.field_name A field in a user-defined or %ROWTYPE record, previously declared within the … user_tables WHERE ROWNUM Constants and Variables, %ROWTYPE Attribute

User's Guide and Reference, 10g Release 1 (10.1)

5 Using PL/SQL Collections and Records

Assigning Values to Recordsthe records have the same type. dept2_info:= dept3_info; END; / You can assign a %ROWTYPE record … different types. But because rec2 is based on a %ROWTYPE, we can -- assign is to rec1 as long as they … %ROWTYPE; BEGIN SELECT last_name, employee_id INTO rec2 FROM employees WHERE ROWNUM You can also use

User's Guide and Reference, 10g Release 1 (10.1)

13 PL/SQL Language Elements

13 PL/SQL Language ElementsRAISE Statement Records RESTRICT_REFERENCES Pragma RETURN Statement ROLLBACK Statement %ROWTYPE

Release 1.8, 10g Release 1 (10.1)

Using Embedded PL/SQL

User-defined Recordsnamed num_tab as follows: num_tab(9)... User-defined Records You can use the %ROWTYPE attribute to

User's Guide and Reference, 10g Release 1 (10.1)

5 Using PL/SQL Collections and Records

Querying Data into Collections of RecordsTABLE OF employees%ROWTYPE; underpaid EmployeeSet; -- Holds set of rows from EMPLOYEES table. CURSOR c1 … IS SELECT first_name, last_name FROM employees; TYPE NameSet IS TABLE OF c1%ROWTYPE; some_names