NEWS: Total Picture Views: 157232 | Total Article Views: 168307 | 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 If Example SQL

Description:

In this example I will be showing Explicit Loop

Code:

DECLARE
	blake_sal emp.sal%TYPE;
	ward_sal emp.sal%TYPE;
BEGIN
	FOR rec IN (SELECT * FROM emp) LOOP
		IF rec.ename = 'BLAKE' THEN
			blake_sal := rec.sal;
		ELSIF rec.ename = 'WARD' THEN
			ward_sal := rec.sal;
		END IF;
	END LOOP;
	IF blake_sal > ward_sal THEN
		DBMS_OUTPUT.PUT_LINE('Blake makes more');
	ELSE
		DBMS_OUTPUT.PUT_LINE('Blake does not make more');
	END IF;
END;
/
Attachments: None

Tags: PLSQL

Total Views: 744

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.