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 wwww.RebellionRider.com
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : www.rebellionr...
Previous Tutorial
► SELECT...INTO statement in PL/SQL • PL/SQL tutorial 3: SEL...
-------------------------------------------------------------------------
►►►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
/ rebellionrider
/ imthebhardwaj
/ rebellionrider
plus.google.co...
/ mannbhardwaj
/ rebellionrider
/ rebellionrider
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 RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

[@nalinaksheepanda1596]

It is becoming interesting now. I was searching for a PLSQL playlist and I found yours. Love your teaching approach.

[@manish9589]

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

[@muhammadraihansuryanom234]

just leave a like and subs to him.

[@orlas135]

I was looking for a PL/SQL for too much time and finally i did it. Thank you very much for your amazing explanations.

[@ll_ashu_ll]

AFTER LONG TIME I FIND YOUR CHANNEL YOUR TEACHING MATHOD IS VERY GOOD AND ALSO YOU GIVE US DEEPLY KNOWLADGE

[@nickdamus5368]

You are saving my course in database design, thanks a lot!!

[@nilimabhosale7494]

Dude this is helping us after 5 years too! Thank you :)

[@berlingawd69]

9 years too

[@trav11ify]

watching this in feb 2022 for a new job...these videos are a god send...thank you sir....

[@sameermohammed1285]

hats of internet n youtube for letting me meet this wonderful sir. i learned alot from u Manish sir "RebellionRider"

[@priyapriya-cb5tt]

TQ so much Manish Sharma for giving such easy explanation

[@shivampatel8850]

You explained in a very well manner please never stop making such useful videos

[@pruthvirajhaladkar]

Thank you sir ? I was confused while teaching in class because i have bunked lectures . But you solved my problem ! Thanks so much.

[@AakashPanditOfficial]

Worked 3years in IT. Never knew this btw. Thanks for the information

[@haribabukallagunta2125]

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

[@nabinghosh4470]

bhai tussi great ho...taufa kuboool karo....love u bhai.....my doubts are clear now..

[@Rebellionrider]

Thank you so much. I am glad that you find my videos helpful.

[@adil47ful]

One of the best explanation. .explained sooo simply!!

[@Rebellionrider]

Thank you so much.

[@sindhugang290]

Thank you for explaining in a simple way... it really means a lot to me.

[@santoshritchie259]

teaching style is simple and easy thank you for this content. bro

[@simonkalu]

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

[@oscarda77]

Excellent concise explanation. Thank you!!

[@mmscoalnet3082]

AAP BAHUT ACHHE SE TEACH KARTE HAI SIR JHAKAS

[@ericzong1189]

ok,after 4 tutorials you earned a subscribe ! Good job!

[@Rebellionrider]

I am really happy to know that my videos helped you. Your appreciation and love means a lot to me.

[@anuradhawickramasinghe6585]

you are better than my higher diploma ADBMS lecturer

[@Rebellionrider]

Thank you so much

[@simonkhemali8392]

What a video 📷📷📷

[@Rebellionrider]

Thank you so much for the positive vibes! 🌟 I'm thrilled you enjoyed the video. If there's a specific SQL topic or skill you're eager to delve deeper into, feel free to share! If you could quickly master any advanced SQL skill, what would it be and why? Happy watching! 🚀

[@anusuyaperumal2155]

thank you very much now I have a clear view about anchor datatype

[@Rebellionrider]

I am glad you enjoyed the content. Your appreciation means a lot to me.

[@eray.1605]

best plsql tutorial on youtube

[@vickypatekar9532]

Great Teaching Manish Sir

[@SunilKumar-ie2jh]

very helpful video bro👍 but only thing that I want is please speak slowly so that we can understand

[@karhanh2248]

Very good explaination. Thanks !

[@tapanjeetroy8266]

U r doing a great job...

[@navinly1030]

Great tutorial ever!

[@AakashPanditOfficial]

Very helpful sir. Need more links for the information

[@3170ccp]

Good video and best teacher!!can I get ur source scipts?

[@Mikazoe1012]

Very clear explanation. Thank you !

[@archanavyakaranam2164]

You are doing the wonderful job, God bless you.

[@lehaswinipalla3365]

great series, much thankss!!

[@Rebellionrider]

You're very welcome!

[@sakshisrivastava5949]

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

[@AmarSingh-co1fq]

www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-ea-42-3211401.html But make sure you have Oracle Database Express Edition 11g Release 2 for Windows x64 or higher installed prior to installing sql developer

[@ragunathsaravanan8601]

Sir!! I have a doubt I am beginner and i dont have tried it in ma system.. Ma doubt is we have to blocks so the output should show the clark twice But it shows only once Why so?

[@raytang1867]

Wish all college professors like you!

[@varshapathak3427]

Nice explanation Manish...:)

[@sridhardurairaj2317]

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

[@swati8201]

U r my favourite as always ❤️

[@mezamortus]

Amazing tutorial series

[@Rebellionrider]

Glad you like them!

[@FarhanKhan-if9ey]

If we export this database and import into other computer with an other database name, will this anchored query worked? Because it must contain a database name while coding but its changed when import to other device?

[@akkiyethi]

Very Productive learnings :) Thanks Manish sir :)

[@AnkitSingh-tz3ix]

simply great

[@sugandhadogra1781]

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

[@lalitya2609]

It a very simple term . . sql is structured query language, its a basic query related language used to retrieve , manipulate , store data and also for creating/atering tables. We cannot write code in SQL where as PLSQL is procedural language SQL which means we can use SQL queries in it along with writing logic for the data manipulation or storage

[@MyMengie]

plsql is more advance and We can use procedure and function in it that sql does not have it.

[@plan.b2]

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. Thanks

[@nannuuuuu]

Dude you're an angel 🤝🤝♥️

[@Rebellionrider]

Thank you so much for your appreciation it means a lot to me

[@Abhi-yp9um]

Can you please provide complete PDF of your plsql blog.

[@merktor2090]

Good job.

[@nazimiqbal9439]

awesome boss! thank you!!

[@vaishh1765]

great tut bro

[@hiwelc]

great videos ....very nice explanation

[@callmecheese4696]

Thank you. U just save my life.

[@lachulax8711]

great explanation manish

[@Pretty-Skie]

Thankyou so much sir!!

[@ramyak4972]

i am executing the program its getting PL/SQL procedure successfully completed. but dbms statement is not executing even though i gave serveroutput on can you please suggest how i can see the output

[@Rebellionrider]

Can't say anything until I see the code.

[@genetsebehat4853]

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

[@عبدالقادرعبدالرحمنعبدالله]

Man, you are the real one whom i have been looking for ! I got U ! Thanks for the great work you did for us.

[@dhanushkumars7317]

Thankyou sir

[@prabhur764]

ANOTHER ONE IMPORTANT THING Is: 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 SET SERVEROUTPUT ON; DECLARE FR_NA employees.emp_name % TYPE; BEGIN SELECT emp_name INTO FR_NA FROM employees WHERE emp_id=105; DBMS_OUTPUT.put_line(FR_NA); SELECT salary INTO FR_NA from employees WHERE emp_id=105; DBMS_OUTPUT.put_line(FR_NA); END;

[@SanjaySony303]

Hi Manish what it mean %? in pl/sql

[@Rebellionrider]

+Sanjay Sony Great question, I suggest you to read this blog bit.ly/anchored-datatype

[@shaheenshaikh6701]

But i tried even if ewe change datatype of base table to char and in our example if its varchar2 there is no error

[@onlineimambaragadarefatima4231]

How to download the paratice database and from where

[@navneetkaur4907]

great

[@shubhendumishra1421]

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

[@simonkalu]

That dot(.) means reference on that class or object property. For example students.first_name is equal to class.property

[@endone3661]

5 yrs ago but still relevant O.o ! don't mind me XD

[@andrikazainal507]

Hey sir How about %ROWTYPE ?

[@aakashdurai2909]

english is very good yaarrr

[@YounasKhan-yv8er]

Keep It...#ManishSharma

[@vijayapatil5371]

which software is use to run pl/sql program.

[@AmarSingh-co1fq]

www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-ea-42-3211401.html But make sure you have Oracle Database Express Edition 11g Release 2 for Windows x64 or higher installed prior to installing sql developer

[@sarfarazmakandar4684]

Awesome!!!!

[@kshitijwardhanahirwar6043]

set serveroutput on; declare v_name varchar(45); begin select name into v_name from employee where id=1001; dbms_output.put_line(v_name); end; / alter table employee modify name char(90); / set serveroutput on; declare v_name varchar(45); begin select name into v_name from employee where id=1001; dbms_output.put_line(v_name); end; / it is working fine i altered column datatype in my db...please clr it

[@anupamachandra6338]

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

[@shaheenshaikh6701]

When I tried the same program I didn't get the error

[@madhavikatta7346]

Can anyone tell me how to print datatype of variable

[@aakashdurai2909]

ur a cool guy

[@Darshankatthi_01]

which IDE used

[@Rebellionrider]

Oracle SQL Developer. Here is how to set it up kzbin.info/www/bejne/sJ3Md2uhjbugm6c

[@RajeshSharma-to4bm]

Sir I want to say one thing that if anyone like your video then they willing like, subscribe and share the video as well as the channel you don't have to show and tell the viewer to do so😈😈

[@farhadbf9766]

Thanks for this tutorial but I'm requesting you should slowly provide your teaching then everyone can understand very easily . You should not go quickly launch your sound. It will must be helpful for all of us if you try to gradually teach on topic but not quickly.

[@Rebellionrider]

Thanks, Farhad for your valuable feedback. Will keep that in mind next time.

[@Kevzhang2012]

0 dislike so far which is awsome

[@gamercumcoder2496]

Wow brother,you're genius.

[@vaibhavdate7993]

Thanks sir

[@onlineimambaragadarefatima4231]

How to download the paratice database and from where

[@Rebellionrider]

For practice you can use HR schema. Refer this video of mine and learn how to unlock it kzbin.info/www/bejne/rZ-8mmWIps53rM0

[@skdonsingh]

Thanks sir