Implicit Cursor

PHOTO EMBED

Wed Sep 22 2021 23:50:08 GMT+0000 (UTC)

Saved by @kaveen

DECLARE
	CURSOR stock_cur IS
    	SELECT s.address,s.salary
		FROM customers s;
	stock_rec stock_cur%rowtype;
BEGIN
	FOR stock_rec in stock_cur LOOP
    	dbms_output.put_line('Company : ' || stock_rec.company || '- Current Price : ' || stock_rec_price);

END LOOP;

END;
	
content_copyCOPY