Table-based records

Phones table

PHONE_IDPHONE_NAMEPRICE
1Galaxy Note Edge700
2N910 Galaxy Note 4600
3Galaxy S5 Duos 4G500
4iPhone 5S600
5iPhone 6 Plus900

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