You have been asked to define a data block based on a JOIN of multiple tables. The read-only data will be used for calculations and lookups.
The DBA is on holiday and is unable to define a view on the database server. What is the simplest way for you to continue to build the form?
A.
Define a data block based on a Ref Cursor.
B.
Define a data block based on a Table of Records.
C.
Define a data block based in a From Clause query.
D.
Define a data block based on a combination of Ref Cursor and a Table of Records.
E.
Define a data block based on a Ref Cursor and define Transactional triggers for controlling DML statements.