In a package if we have 10 procedures or functions,How to
know which will execute first?
Answer Posted / guest
1.Inner\Sub Group statements are Executed
2.Procedures\Functions having normal fetching stmt is
executed first
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Explian rowid, rownum?
Can we create clustered index without primary key?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
how to use 'mysql' to run sql statements? : Sql dba
What is memory optimized?
What is a call statement? Explain with an example.
Differentiate between sga and pga.
What is number function in sql?
What is the maximum number of columns in sql table?
What will you get by the cursor attribute sql%found?
How do I filter in sql profiler?
define join and explain different type of joins? : Sql dba
what does it mean to have quoted_identifier on? : Sql dba
Can we use distinct and group by together?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?