PL/SQL tutorial 4: Anchored Datatype (%TYPE) in PL/SQL By Manish Sharma RebellionRider

Anchored datatype or %TYPE in PL/SQL are those data type which you assign to a variable based on a database object. Watch this PL/SQL Tutorial 4 and leanr about %TYPE with examples By Manish Sharma from

Blog :
Previous Tutorial
► SELECT…INTO statement in PL/SQL
►►►Let’s Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on

You can also Email me at
for E-mail address please check About section

Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos

This is Manish from


Yuxiang Zhang says:

0 dislike so far which is awsome

sakshi srivastava says:

Hey Manish very good videos. Please let me know from where can I download SQL developer for practice purpose.??

coderz says:

You can declare it to any one column type and use it as any column for ex:declare v_fname students.stu_id %types
and you can use integer or varchar in that declared variable(v_fname)
another example
DECLARE FR_NA employees.emp_name % TYPE;
SELECT emp_name INTO FR_NA FROM employees WHERE emp_id=105;
SELECT salary INTO FR_NA from employees WHERE emp_id=105;

Funsho Jooda says:

Thank you

vijaya Patil says:

which software is use to run pl/sql program.

Younas Khan says:

Keep It…#ManishSharma

Alok Sharma says:

great videos ….very nice explanation

Zaiid Raza says:

No bullshit. Simply full of content

Kshitij wardhan ahirwar says:

set serveroutput on;
v_name varchar(45);
select name into v_name from employee where id=1001;
alter table employee modify name char(90);
set serveroutput on;
v_name varchar(45);
select name into v_name from employee where id=1001;

it is working fine i altered column datatype in my db…please clr it

Sridhar Durairaj says:

Thanks for this video. ur videos are easy to learn and understand

haribabu kallagunta says:

you are a great teacher your videos on triggers are very useful for beginners thank you for giving these videos

Sugandha Dogra says:

hey manish , so sql is different from pl/sql ? or both are same ? is d way coding done is also same in both ?

Sunil Singh says:

Thanks sir

ARCHANA Vyakaranam says:

You are doing the wonderful job, God bless you.

Simon Kalu says:

Thank you Manish. Achored datatype is a wonderful topic for me

Shubhendu Mishra says:

Hey Sir,

Sir why we are using this dot(.) b/w student and first_name

tapanjeet roy says:

U r doing a great job…

Varsha Pathak says:

Nice explanation Manish…:)

David Adenzon says:

Thank you !

lachu lax says:

great explanation manish

عبد القادر عبدالرحمن عبدالله says:

Man, you are the real one whom i have been looking for ! I got U !

Thanks for the great work you did for us.

Rui Imsa says:

Wish all college professors like you!

Csongor Gerdán says:

Hi Manish,

Thank you for this great series.
I encountered a question during watching this video.
I got different error message after ALTER TABLE and SELECT INTO:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 4
ORA-06512: at “SYS.DBMS_SQL”, line 1721

I could not see anything related to NULL or large integer assignments what I can see in the video at 5:25. Could you explain this difference, please? I am confused a bit.

Genet Sebehat says:

You are great!  I want to be PL/SQL Developer.  Thanks!

Sarfaraz Makandar says:


akshay yethirajam says:

Very Productive learnings :) Thanks Manish sir :)

Manish Rana says:

One of the best teacher! I have learned a lot from you and really don’t know how to repay this.

anupama chandra says:

where is student table? do we need to create student table?

Sanjay Sony says:

Hi Manish what it mean %? in pl/sql

Write a comment


Human Verification: In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.

Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!

Send this to a friend

▷ Other ReviewsVehicles▷ Show Cars▷ Motorbikes▷ Scooters▷ Bicycles▷ Rims & Tires▷ Luxury BoatsFashion▷ Sunglasses▷ Luxury Watches▷ Luxury Purses▷ Jeans Wear▷ High Heels▷ Kinis Swimwear▷ Perfumes▷ Jewellery▷ Cosmetics▷ Shaving Helpers▷ Fashion HatsFooding▷ Chef Club▷ Fooding Helpers▷ Coktails & LiquorsSports▷ Sport Shoes▷ Fitness & Detox▷ Golf Gear▷ Racquets▷ Hiking & Trek Gear▷ Diving Equipment▷ Ski Gear▷ Snowboards▷ Surf Boards▷ Rollers & SkatesEntertainment▷ DIY Guides▷ Zik Instruments▷ Published Books▷ Music Albums▷ Cine Movies▷ Trading Helpers▷ Make Money▷ Fishing Equipment▷ Paintball Supplies▷ Trading Card Games▷ Telescopes▷ Knives▷ VapesHigh Tech▷ Flat Screens▷ Tech Devices▷ Camera Lenses▷ Audio HiFi▷ Printers▷ USB Devices▷ PC Hardware▷ Network Gear▷ Cloud Servers▷ Software Helpers▷ Programmer Helpers▷ Mobile Apps▷ Hearing AidsHome▷ Home Furniture▷ Home Appliances▷ Tools Workshop▷ Beddings▷ Floor Layings▷ Barbecues▷ Aquarium Gear▷ Safe Boxes▷ Office Supplies▷ Security Locks▷ Cleaning ProductsKids▷ Baby Strollers▷ Child Car Seats▷ Remote ControlledTravel▷ Luggages & Bags▷ Airlines Seats▷ Hotel Rooms▷ Fun Trips▷ Cruise Ships▷ Mexico Tours