What is the best technique of debugging large and fragmented dynamic SQL.
Latest Answer: The biggest challenge in debugging dynamic sql is to re-construct the actual query that had been sent to the sql parser at run time. The complexity increase as the size and number of fragmentation of the query increases.As per my experience to debug dynamic ...
Performance wise which is a better option if-else construct or a decode? Why
Latest Answer: The answer to this question would actually depend on the type of applicability of the usage that is being done. i.e. is it required in a query or in a PLSQL block. If it is in a query we cannot use if....else we will have to use decode. In a PLSQL block ...
You have a package called A and one function in that packgae called XYZ.If you need to call that function in second packaged B, How will you call?
Latest Answer: To access a function or a procedure that is defined in package 1 from a procedure defined in package 2, just ensure that the package 1's specification has those functions/procedure definitions defined.Function/Procedures that are defined in a packages's ...
How will you stop an infinite loop without closing the program?
Latest Answer: use the EXIT statementThis will stop the looping and proceed to the next executable statement.or EXIT WHEN condition ...
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?
Latest Answer: Triggers are PLSQL block or Procedures which get executed whenever:1) an INSERT, DELETE or UPDATE happens on a table. 2) DDL like ALTER or CREATE happens on a table. 3) an INSTEAD OF trigger on a view is issued - If a DML operation is issued on a view, ...
What is call by value and call by reference in parameters (IN, OUT, INOUT)?
Latest Answer: In Parameter:: call by reference OUT Parameter: call by valueIN OUT Parameter: call by valueif you use the hint NOCOPY with OUT Parameter and IN OUT Parameter then ::: call by reference ...
what is the difference between an explicit cursor and select into statement?
Latest Answer: A Select..into statement is even an implicit cursor concept. But the disadvantage is it can't handle if the select statement returns more than 1 row.So, implicit cursor opens before the statements executed and closed after automatically and hence ...
How can we find the select statement is indexed or not?
Latest Answer: 1. using AUTOTRACESQL> SET AUTOTRACE ON TRACEONLYSELECT * FROM emp WHERE emp_name = 'ABC';2. Using EXPLAIN PLANSQL> EXPLAIN PLAN forSELECT * FROM emp WHERE emp_name = 'ABC';The advantage ...
Why are we not supposed to include TCL statements in a trigger?
Latest Answer: The trigger is fired when an event occurs while manipulating the data in table.So the trigger applies a lock on it restricting others to modify it.Locks are released when a TCL command is executed. The trigger can't understand whether to release the ...
Why PL/SQL does not support retriving multiple records?
Latest Answer: Retriving multiple records is a basic feature of SQL where we fetch the data using SELECT statement.SELECT * FROM emp;This itself gives us multiple records. There is no additional feature required to do the same in PL/SQL.At the same time, PL/SQL ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
