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

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?

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

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

simply great

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

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

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

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

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

Excellent concise explanation. Thank you!!

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?

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😈😈

Wow brother,you're genius.

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

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

Good job.

Great tutorial ever!

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

U r my favourite as always ❤️

Very clear explanation. Thank you !

Dude you're an angel 🤝🤝♥️

great

Thank you. U just save my life. <3

Hey sir How about %ROWTYPE ?

awesome boss! thank you!!

Thankyou sir

Can anyone tell me how to print datatype of variable

Thanks sir

Very good explaination. Thanks !

great tut bro

Very helpful sir. Need more links for the information

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

Amazing tutorial series

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

TQ so much Manish Sharma for giving such easy explanation

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

How to download the paratice database and from where

How to download the paratice database and from where

Thank you so much for your detailed explanation.

I have tried to correct this error but it's not working. could you please help me out with this error message,

CODE :

set serveroutput on;
clear screen;

DECLARE
v.category_name products.category_name%type;
v.item_description products.item_description%type;
BEGIN
select category_name , item_description into v.category_name , v.item_description from products where item_number = '904616';
END;

ERROR:
Error starting at line : 37 in command -
DECLARE
v.category_name products.category_name%type;
v.item_description products.item_description%type;
BEGIN
select category_name , item_description into v.category_name , v.item_description from products where item_number = '904616';

END;
Error report -
ORA-06550: line 2, column 6:
PLS-00103: Encountered the symbol "." when expecting one of the following:

constant exception <an identifier>
<a double-quoted delimited-identifier> table columns long
double ref char standard time timestamp interval date binary
national character nchar
The symbol "table was inserted before "." to continue.
ORA-06550: line 3, column 6:
PLS-00103: Encountered the symbol "." when expecting one of the following:

constant exception <an identifier>
<a double-quoted delimited-identifier> table columns long
double ref char standard time timestamp interval date binary
national character nchar
The symbol "table was inserted before "." to continue.
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:

AAP BAHUT ACHHE SE TEACH KARTE HAI SIR JHAKAS

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

Can you please provide complete PDF of your plsql blog.

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

great series, much thankss!!

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

Thankyou so much sir!!

which IDE used

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

What a video 📷📷📷