Review the code below then answer the questions that follow. LINE NUMBER 1 Create or replace Function House_Details(h_num in townhouse.house_num%Type) 2 RETURN vorchar2 3 IS 4 details varchar(100); 5...

Defend the use of a function instead of a procedure using examples from the query.

Extracted text: Review the code below then answer the questions that follow. LINE NUMBER 1 Create or replace Function House_Details(h_num in townhouse.house_num%Type) 2 RETURN vorchar2 3 IS 4 details varchar(100); 5 cursor c1 is select c.cust_id ||R'|| t.build_price ||,'Il pa.purchase_date ||'Il pa.purchase_amt 6 from CUSTOMER C, TOWNHOUSE t, PURCHASE_AGREEMENT pa where c.cust_id = pa.cust_id and t.house_num = pa.house_num 10 and t.house_num = h_num; 11 BEGIN 12 open c1; 13 fetch cl into details; 14 if c1%notfound then 15 details := 'No house information found; 16 end if: 17 RETURN details; 18 close c1; 19 EXCEPTION 20 WHEN OTHERS THEN 21 raise_application_error(-20001, 'An error was encountered - '||SQLCODE||'-ERROR- 22 '1/SQLERRM); 23 END; 24 25 select House_Details(3) from dual;