Variable attributes | Anchor notations | %type, %rowtype in Oracle PL SQL Interview Questions And Answers For Experienced & Freshers | Interview Preparation

Variable attributes | Anchor notations | %type, %rowtype in Oracle PL SQL Interview Questions And Answers For Experienced & Freshers | Interview Preparation

Variable attributes used in place of datatypes in variable declaration.

There are two types of variable attributes:

1) Column level attribute
2) Row level attribute

1) Column level attribute - 

In this method we are defining attributes for individual columns.

Column level attributes are represented by %type.

Whenever we are using column level attributes oracle server internally allocates memory for the variables as same as the corresponding column datatype in a table.

e.g. v_ename emp.ename%type ;

2) Row level attribute -

In this method single variable can represent all different datatypes in a row within a table. This variable also called as record type variable. row level attributes represented by %rowtype.

e.g. i emp%rowtype ;

Please do check our daily posts, videos for beneficial informations, in case of any additional queries please do contact us, we are happy to assist you.

Please Do SUBSCRIBE our Youtube Channel and Support us :-
https://www.youtube.com/a4uofficial

If any difficulties regarding our posts, videos or other problem you can direct contact us:- allforyoucreators@gmail.com

If you found this post was helpful then please don't forget to SUBSCRIBE our channel.

Subscribe us for more such posts, videos and updates.. It's Free!!

Subscribe here : https://www.youtube.com/a4uofficial

For Businesses Inquiries :- allforyoucreators@gmail.com

_____________________________________________________________________________

Join Us on Social Media -

Like our Facebook Page :- https://www.facebook.com/a4u0fficial/

Follow me on Instagram :- https://www.instagram.com/allforyouofficial.01/

Twitter :- https://twitter.com/a4uofficial

Website :- https://allforyouofficial.com/

PLEASE SUBSCRIBE US FOR MORE POSTS, VIDEOS AND STAY TUNED..

CREATIVE, INFORMATIVE & BENEFICIAL CONTENTS TO BE FOUND ON OUR CHANNEL!!

BECAUSE WE KEEP UPLOADING VIDEOS ON YOUTUBE FOR YOU..

ALL WE NEED IS YOUR SUPPORT ❤

=▶ Thanks for your Love and Support ◀=

Copyright ©All For You Official