What should be the return type for a cursor variable. Can we use a scalar data type as return type? The return type for a cursor must b...
What should be the return type for a cursor variable. Can we use a scalar data type as return type? The return type for a cursor must b...
What is an Lov? A list of values is a single or multi column selection list displayed in a pop-up window What is a record Group? A ...
What are the PL/SQL Statements used in cursor processing ? DECLARE CURSOR name, OPEN cursor name, FETCH cursor name INTO or Record typ...
What is a Check Box? A Check Box is a two state control that indicates whether a certain condition or value is on or off, true or fals...
When is cost based optimization triggered? (for DBA) It's important to have statistics on all tables for the CBO (Cost Based Optim...