Snippet Name: %TYPE vs %ROWTYPE - What's the difference?
Description: Both %TYPE and %ROWTYPE are used to define variables in PL/SQL as it is defined within the database. If the datatype or precision of a column changes, the program automatically picks up the new definition from the database.
The %TYPE and %ROWTYPE constructs provide data independence, reduce maintenance costs, and allows programs to adapt as the database changes.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 06th, 2009
-- %TYPE is used to declare a field with the same type as -- that of a specified table's column: DECLARE
v_EmpName emp.ename%TYPE;BEGINSELECT ename INTO v_EmpName FROM emp WHEREROWNUM=1;DBMS_OUTPUT.PUT_LINE('Name = '|| v_EmpName);END;/-- %ROWTYPE is used to declare a record with the same types as -- found in the specified database table, view or cursor: DECLARE
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.