Table-based records

Phones table

PHONE_ID PHONE_NAME PRICE
1 Galaxy Note Edge 700
2 N910 Galaxy Note 4 600
3 Galaxy S5 Duos 4G 500
4 iPhone 5S 600
5 iPhone 6 Plus 900

Table-based records

DECLARE
	rec PHONES%rowtype;
BEGIN
	SELECT * INTO rec
	FROM PHONES
	WHERE price = 900;
	
	DBMS_OUTPUT.PUT_LINE
	('Id: '||rec.PHONE_ID||' Name: '||rec.PHONE_NAME||' Price: '||rec.PRICE);
END;
/

Output

Id: 5 Name: iPhone 6 Plus Price: 900