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


Please Help Members By Posting Answers For Below Questions

How can one get sql*loader to commit only at the end of the load file? : aql loader

563


What is dense_rank in sql?

539


How you improve the performance of sql*loader? : aql loader

574


How sql query is executed?

550


what are the differences between char and varchar? : Sql dba

524






How to change sql*plus system settings?

540


What is use of package in pl sql?

530


Which is faster subquery or join?

656


Which join is like inner join?

559


What do you understand by pl/sql cursors?

546


What has stored procedures in sql?

593


How do I debug a stored procedure?

625


How to run sql statements through the web interface?

511


What is the difference between microsoft access and sql?

496


What is the difference between partitioning and sharding?

523