NEWS: Total Picture Views: 155283 | Total Article Views: 165631 | Top 5 Most Popular Article: 1. Am I Stuck Algorithm with Becker Robot | 2. PickUpThings with Becker Robot | 3. How to read a JSON and work with it | 4. Encrypted Data GUI (Download .Zip) | 5. Create Wall and Things with Becker

Explicit Loop Example 2 SQL

Description:

In this example I will be showing Explicit Loop.

Code:

DECLARE
	v_ename emp.ename%TYPE;
	v_sal emp.sal%TYPE;
	v_deptno emp.deptno%TYPE;
	CURSOR c_emp IS
		SELECT ename, sal, deptno
		FROM emp
		WHERE job = 'MANAGER';
BEGIN
	OPEN c_emp;
	LOOP
		FETCH c_emp INTO v_ename, v_sal, v_deptno;
		IF c_emp%NOTFOUND THEN
			EXIT;
		END IF;
		DBMS_OUTPUT.PUT_LINE(v_ename||' '||v_sal||' '||v_deptno);
	END LOOP;
	CLOSE c_emp;
END;
/
Attachments: None

Tags: Cursor PLSQL NOTFOUND

Total Views: 790

My name is Jean-Mathieu

I created this website so other people could enjoy finding useful stuff easier. If you have any question do not hesitate to contact me.

jean8mathieuCreated on 02/25/15


affiliate_link

Disclosure: We are a website that needs compensation to operate like any other website on the internet.
We may receive consideration for our reviews but we are totally unbiased and do not accept paid reviews or fake reviews claiming to be something they are not.