--general--
different types of report layouts?
tabular, form-like, mailing label, form-letter, group left, group above, matrix,
matrix with group
which are the different report triggers and firing sequence?
b-r,b-p, b/w-p,a-p,a-r
will the before & after paraform triggers fire if there is no parameters? yes
is it possible to write data into database from report triggers? yes
how to cancel a report if a validation fails? srw.program_abort;
what is matrix reports? minimum how many groups are required to create it? 4
what is external query?
--data model--
what are the different types of objects that can be created on the datamodel screen?
what are the different types of data links?
what is ref cursor query?
A ref cursor query uses PL/SQL to fetch data. Each ref cursor query is associated with a PL/SQL
function that returns a strongly typed ref cursor. The function must ensure that the ref cursor
is opened and associated with a SELECT statement that has a SELECT list that matches the type of
the ref cursor. A ref cursor query uses PL/SQL to fetch data for the report.
In a ref cursor query, you specify a PL/SQL function that returns a cursor value from
a cursor variable.
Definition Level query
On Failure No data is returned to the query.
Usage Notes
n When you make a ref cursor query the child in a data link, the link can only be
a group to group link. It cannot be a column to column link.
n If you use a stored program unit to implement ref cursors, you receive
the added benefits that go along with storing your program units in the Oracle database.
--layout--
what is header, footer & margin?
what is repeating frame?
what are the different types of print directions?
what are anchors? how many types?
how to display a image in reports?
how to change the format of an item at run time?
what is conditional formating?
how many report layouts is possible?
how to link a field to a broiler text?
what is flex mode and confine mode?
tell few commands u have used in srw package?
drill down reports?
