Which statement is true about user-defined records?
Which statement is true about user-defined records?
User-defined records can be returned from a function. This is a common feature in many programming languages where user-defined types, such as records, are used to encapsulate multiple fields and can be returned from functions to provide structured data.
A is correct
A es correct.
create or replace package mypackage is type mytype is record( a number ); function myfunction return mytype; end; / create or replace package body mypackage is function myfunction return mytype is l_record mytype; begin l_record.a := 69; return l_record; end myfunction; end; / set serveroutput on; begin dbms_output.put_line(mypackage.myfunction().a); end; /
I'm returning a record from a function
I think the answer is A
I think answer is A
Dont't think so as you can use functions in select statements