The concept of overloading in PL/SQL relates to the idea that you can define procedures and functions with the same name. PL/SQL does not look only at the referenced name, however, to resolve a procedure or function call. The count and data types of formal parameters are also considered.
PL/SQL also attempts to resolve any procedure or function calls in locally defined packages before looking at globally defined packages or internal functions. To further ensure calling the proper procedure, you can use the dot notation. Prefacing a procedure or function name with the package name fully qualifies any procedure or function reference.
Interview Questions
- Accounts Payable Interview Questions (25)
- ACLS BLS Certification (5)
- Administrative Interview Questions (35)
- Airline Interview Questions (21)
- AJAX Interview Questions (202)
- ASP.Net Interview Questions (322)
- Baby Sitter Interview Questions (12)
- Bank Interview Questions (50)
- Basic Interview Questions (26)
- BlueTooth Interview Questions (177)
- Bookkeeper Interview Questions (42)
- C# Interview Questions (155)
- C/C++ Interview Questions (210)
- Call Center Interview Questions (68)
- Citizenship Interview Questions (23)
- Cobol Interview Questions (167)
- Computer Architecture Interview Questions (151)
- Computer Networks Interview Questions (160)
- Consulting Interview Questions (33)
- CSS Interview Questions (171)
- Customer Service Interview Questions (28)
- Data Structure Interview Questions (151)
- Data WareHousing Interview Questions (152)
- Database Interview Questions (421)
- EJB Interview Questions (200)
- Financial Interview Questions (130)
- Google & Microsoft Interview Questions (190)
- Hospitality Interview Questions (16)
- HR Interview Questions (173)
- HTML (155)
- Interview Questions for Employers (11)
- Interview Tips (169)
- Investment Banking Interview Questions (11)
- J2EE Interview Questions (249)
- J2ME Interview Questions (171)
- Java Interview Questions (485)
- JavaScript (167)
- JMS Interview Questions (154)
- JSP Interview Questions (155)
- Linux Interview Questions (176)
- MCSE Interview Questions (13)
- Medical Interview Questions (16)
- Microprocessors Interview Questions (162)
- Nanny Interview Questions (14)
- Networking Interview Questions (204)
- Nursing Interview Questions (35)
- Object Oriented Interview Questions (169)
- Operating System Interview Questions (154)
- Oracle Interview Questions (187)
- Other Interview Questions (169)
- Payroll Interview Questions (10)
- PeopleSoft Interview Questions (164)
- Pharmaceutical Interview Questions (10)
- PHP Interview Questions (158)
- Police Interview Questions (10)
- Police Officer Interview Questions (10)
- Private Equity Interview Questions (12)
- Puzzles (152)
- Questions to Ask during an HR Interview (161)
- Retail Interview Questions (12)
- Sales Interview Questions (10)
- SAP-ABAP Interview Questions (227)
- Secretary Interview Questions (11)
- Siebel Interview Questions (172)
- Software Testing (177)
- SQL Interview Questions (314)
- Struts Interview Questions (248)
- System Integration Interview Questions (173)
- Teacher Interview Questions (10)
- Teaching Assistant Interview Questions (11)
- Team Leader Interview Questions (13)
- Telephone Interview Questions (24)
- TIBCO Interview Questions (14)
- University Interview Questions (12)
- UNIX Interview Questions (184)
- VB.NET Interview Questions (154)
- VBScript Interview Questions (162)
- Visual Basic Interview Questions (144)
- XML Interview Questions (188)