What are two parts of package?
Submitted by: AdministratorThe two parts of package are PACKAGE SPECIFICATION & PACKAGE BODY. Package Specification contains declarations that are global to the packages and local to the schema.
Package Body contains actual procedures and local declaration of the procedures and cursor declarations.
Submitted by: Administrator
Package Body contains actual procedures and local declaration of the procedures and cursor declarations.
Submitted by: Administrator
Read Online Oracle PL-SQL Job Interview Questions And Answers
Top Oracle PL-SQL Questions
☺ | Explian rowid, rownum?what are the psoducolumns we have? |
☺ | what is the starting oracle error number? |
☺ | What is difference b/w stored procedures and application procedures, stored function and application function? |
☺ | In a Distributed Database System Can we execute two queries simultaneously? Justify? |
☺ | Name the tables where characteristics of Package, procedure and functions are stored? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |