-
Pipe Function and Mutating Trigger
1) Why we use pl/sql array rather than cursor?2) In which condition we use function overloading? 3) What is pipe function?4) What is the mutating trigger? What should be the condition?
-
How to identify missing records in a single-column table?
How to identify missing records in a single-column table ?Column consists of numbers in a ordered manner but the some numbers are deleted from the table in random manner and need to identify those rows.p.s. This table consist of only 1 row.
-
-
Stored Procedure Vs Function
What is the impact of using a stored proc or a function on the performance? Which has a better performance? Also, why is it not possible to use DML in the functions called from a select query?
-
Transaction management in triggers
Can we give COMMIT or ROLLBACK within a trigger?
-
Compiling Specification Part and Body Part
If have 5 procedures in my specification part and used 4 in my body part while compiling will it throw error or not?
-
-
-
-
-
-
-
What is the need of primary key as opposed to using not null and unique ?
We can create a column with' not null+unique' with out using primary key
-
-
Debug PL/SQL Code
How will you debug PL/SQL Code?
-
What is the main purpose of RETURN in functions?
What is the main purpose of RETURN in functions when we can calculate a value and pass it through using OUT mode in procedure or functions?
-
What is a cursor for loop ?
Cursor for loop implicitly declares %ROWTYPE as loop index,opens a cursor, fetches rows of values from active set into fields in the record and closeswhen all the records have been processed. eg. FOR emp_rec IN C1 LOOP salary_total := salary_total +emp_rec sal; ...
-
-
What is the output of the following pl/sql block ?declare v_empno emp.empno%type;begin select empno into v_empno from emp where empno = 10;exception when others then dbms_output.put_line ( 'no data found'); when no_data_found then dbms_output.put_line ( 'ther is no data found ');end;
when others then *ERROR at line 6:ORA-06550: line 6, column 2:PLS-00370: OTHERS handler must be last among the exception handlers of a blockORA-06550: line 0, column 0:PL/SQL: Compilation unit analysis terminated
-
PL/SQL Interview Questions
Ans