0 dislike so far which is awsome

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;

which software is use to run pl/sql program.

great videos ….very nice explanation

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

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

Thanks sir

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

U r doing a great job…

Thank you !

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

Thanks for the great work you did for us.

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

Awesome!!!!

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

Hi Manish what it mean %? in pl/sql