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 : http://bit.ly/anchored-datatype
Previous Tutorial
► SELECT…INTO statement in PL/SQL https://youtu.be/F5eMJhwmCQs
————————————————————————-
►►►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
https://twitter.com/rebellionrider
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/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
Amazon Auto Links: No products found.
0 dislike so far which is awsome
Hey Manish very good videos. Please let me know from where can I download SQL developer for practice purpose.??
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;
Thank you
which software is use to run pl/sql program.
Keep It…#ManishSharma
great videos ….very nice explanation
No bullshit. Simply full of content
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
Thanks for this video. ur videos are easy to learn and understand
you are a great teacher your videos on triggers are very useful for beginners thank you for giving these videos
hey manish , so sql is different from pl/sql ? or both are same ? is d way coding done is also same in both ?
Thanks sir
You are doing the wonderful job, God bless you.
Thank you Manish. Achored datatype is a wonderful topic for me
Hey Sir,
Sir why we are using this dot(.) b/w student and first_name
U r doing a great job…
Nice explanation Manish…:)
Thank you !
great explanation manish
Man, you are the real one whom i have been looking for ! I got U !
Thanks for the great work you did for us.
Wish all college professors like you!
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
You are great! I want to be PL/SQL Developer. Thanks!
Awesome!!!!
Very Productive learnings 🙂 Thanks Manish sir 🙂
One of the best teacher! I have learned a lot from you and really don’t know how to repay this.
where is student table? do we need to create student table?
Hi Manish what it mean %? in pl/sql