Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

%type and %rowtype

733256Sep 17 2011 — edited Sep 17 2011
what is the utility of %type and %rowtype?

%type is used for anchor any column data type (table column type)
%rowtype is used for anchor any object rows structure means for example
tab_emp employee%rowtype;
its mean the tab_emp holds the employee objects structure.

any other utility of this 2...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2011
Added on Sep 17 2011
#plsql
4 comments
191 views