upper_case_cursor

PHOTO EMBED

Sat Jun 08 2024 02:23:20 GMT+0000 (Coordinated Universal Time)

Saved by @signup 

DECLARE
	em t%rowtype;
	empno t.ename%type;
    
BEGIN
	update  t set ename=upper(ename);
	if sql%found then
   		 DBMS_OUTPUT.PUT_LINE(sql%rowcount||' values updated to uppercase.');
   	else 
   		 dbms_output.put_line('not found');
   end if;
END;
/
content_copyCOPY