11. PL/SQL CURSOR [IMPLICIT CURSOR] | PL/SQL Developer Course | TechView Team | Hindi
#techviewteam #plsql
In this video we discuss about oracle PL/SQL IMPLICIT CURSOR with practical example .
This is 11th video from series of videos about PL/SQL. so, you are requested to watch complete playlist for better understanding.
-------------------Video Notes start from here----------------------------
Implicit cursors
Explicit cursors
Implicit Cursors:-
Implicit cursors are automatically created
by Oracle whenever an SQL statement is executed
%FOUND, %ISOPEN, %NOTFOUND, and %ROWCOUNT,
%BULK_ROWCOUNT and %BULK_EXCEPTIONS,
----IMPLICIT EXAMPLE---
CREATE OR REPLACE PROCEDURE UPDATE_CREDIT
(C_ID IN VARCHAR2,
CREDIT IN NUMBER,
OUTPUT_MESSAGE OUT VARCHAR2)
IS
LV_UPDATED_ROWS number;
BEGIN
UPDATE customers
SET CREDIT_LIMIT = CREDIT_LIMIT + 500 WHERE CUSTOMER_ID=C_ID;
IF sql%notfound THEN
OUTPUT_MESSAGE:='CUSTOMER NOT FOUND';
dbms_output.put_line('CUSTOMER NOT FOUND');
ELSIF sql%found THEN
LV_UPDATED_ROWS := sql%rowcount;
OUTPUT_MESSAGE:=LV_UPDATED_ROWS || ' CUSTOMER CREDIT UPDATED';
dbms_output.put_line( LV_UPDATED_ROWS || ' CUSTOMER CREDIT UPDATED');
END IF;
END;
/
----------------
declare
message varchar2(200);
begin
UPDATE_CREDIT (2,400,message);
end;
--------------
Regards
TechView Team
Смотрите видео 11. PL/SQL CURSOR [IMPLICIT CURSOR] | PL/SQL Developer Course | TechView Team | Hindi онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь TechView Team 05 Декабрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 152 раз и оно понравилось 4 людям.