What is the best technique of debugging large and fragmented dynamic SQL.
Latest Answer: Better insert the dynamic SQL statement into a log table. To see the Exact query or if you have Quest Software (TOAD)Â use the SQL monitor or session browser to see what query executed. ...
Performance wise which is a better option if-else construct or a decode? Why
Latest Answer: decode is much faster then If -Else because decode in built already have all the values of the column which we want to decode whereas in if - else statement , we need to explicitly specify.please anyone correct me ...
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: Call the package.procedure (A.XYZ) in the other procedure. This is not possible if XYZ is a private procedure. ...
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: When a cursor name is explicitly assigned to a SELECT statement through CURSOR statement, it is called an explicit cursor. Explicit cursors are generally used to work with more than one row within PL/SQL. It has got the following attributes:1. Defining ...
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: We cannot use TCL statements in triggers, because using them violates the integrity of the transaction. But if we want TCL statements to be used in triggers then that can be implemented by using Autonomous i.e. by providing PRAGMA AUTONOMOUS_TRANSACTION ...
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
