Set - 9

Question 91 :

Can a repeating frame be created without a data group as a base?

Answer :

No


Question 92 :

Is it possible to set a filter condition in a cross product group in matrix reports?

Answer :

No


Question 93 :

What is Overloading of procedures ?

Answer :

The Same procedure name is repeated with parameters of different datatypes and parameters in different positions, varying number of parameters is called overloading of procedures. e.g. DBMS_OUTPUT put_line


Question 94 :

What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Answer :

SQLCODE returns the latest code of the error that has occurred.
SQLERRM returns the relevant error message of the SQLCODE.


Question 95 :

What are the datatypes a available in PL/SQL ?

Answer :

Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE.