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: The Oracle mutating trigger error occurs when a trigger references the table that owns the trigger. The best way to avoid this error is use autonomous transaction in triggers so that the child transaction will be independent of the parent transaction.The ...
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: Explicit cursor- They are defined by programmer.The select statement can return multiple rows as a query result. If you want to process single row at a time then you can define an explicit cursor for this select statement.Cursor is like a temporary ...
How can we find the select statement is indexed or not?
Latest Answer: Use "Explain Plan" command ...
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: Multiple records at a time could be retreved in PL/SQL using BULK COLLECT.To do that you define PL/SQL table, and load it using SELECT ... BULK COLLECT INTO FROM ..Optionaly could be used LIMIT - to limit the number of records retreved ...
How will you debug PL/SQL Code?
Latest Answer: The Best way to debug is by using an AUTONOMOUS TRANSACTION. Create a dummy table and insert into the table using the AT. This wont affect the main code, but one could know which part of the code the execution has reached while the program is ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
