Oracle%rowtype Usage ____oracle

Oracle in%rowtype:

%rowtype: Indicates that the type is a row data type, stored as a row of data, a row with many columns, equivalent to a row of data in a table, or a row of data in a cursor.

The%rowtype effect is that when querying the entire line (SELECT * from EMP;), the efficiency is faster than each field.

For example: V_info emp%rowtype; This type is a row of data types in the EMP table

V_cinfo C_emp%rowtype//The type is a row of data types in the cursor c_emp

Here is an example:

Oracle code: DECLARE r_emp emp%rowtype;    --This type is the type of one row in the EMP table cursor C_emp is a SELECT * from EMP;      BEGIN OPEN c_emp;     LOOP FETCH c_emp into r_emp;        --a row of queries out of the cursor into the defined variable r_emp EXIT when c_emp%notfound;         Dbms_output.put_line (' Employee Name: ' | | r_emp.ename ');      End LOOP;    Close c_emp; End;

Article Origin:

http://advance0683.iteye.com/blog/1055226