IT Courses

Monday, 22 February 2016

What Are the Benefits of Packages?


  • Enforced Information Hiding
  • Object-Oriented Design
  • Top-Down Design
  • Object Persistence
  • Guaranteeing Transaction Integrity
  • Performance Improvement

A Booch diagram for a package:

All of the boxes that lie completely inside the box are private elements, defined only within the body of the package. Boxes that lie on the boundary of the box are public elements, defined in the package specification and implemented (if programs) in the package body. An external program can make direct references only to those package elements that lie on the boundary. But any package element, whether wholly inside the boundary or straddling that line, can reference any other package element.

A boundary in the package delineates that which is publicly available and that which is private or hidden from view. It has particularly important and valuable consequences for data structures defined in a package.


Posted by Tech Praveen at 05:58
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

If you Like my blog Spread it and help friends for whom this blog is useful for their career.

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Total Pageviews

Translate

Followers

Blog Archive

  • ►  2024 (1)
    • ►  May (1)
  • ►  2020 (1)
    • ►  July (1)
  • ►  2019 (2)
    • ►  August (1)
    • ►  March (1)
  • ►  2018 (11)
    • ►  September (5)
    • ►  August (1)
    • ►  July (4)
    • ►  May (1)
  • ►  2017 (1)
    • ►  November (1)
  • ▼  2016 (133)
    • ►  November (1)
    • ►  August (18)
    • ▼  February (112)
      • BACKUP & RECOVERY COMMANDS AND QUESTIONS
      • ORACLE TECHNICAL
      • ORACLE DBA
      • SQL QUERIES WITH ANSWERS
      • SQL QUERIES AND ANSWERS
      • SQL Queries for Interview
      • RDBMS Oracle
      • sql plus questions & answers
      • PL/SQL COLLECTIONS
      • RECORDS
      • PL/SQL ASSOCIATED ARRAY(PAA):
      • SYNTAX TO DROP THE SUB PROGRAMS,functions,Packages...
      • SYNTAX TO KNOW ABOUT ORACLE VERSION
      • SYNTAX TO KNOW ABOUT THE ORACLE GLOBAL NAME:
      • WRITE A PL/SQL BLOCK TO KNOW ABOUT OPERATING SYSTEM?
      • DELETE and SELECT WITH WHERE CLAUSE,ORDER BY CLAUSE
      • SELECT command & OPERATORS
      • DML(SELECT)
      • DIFFERENCE BETWEEN TRUNCATE AND DELETE
      • DML (UPDATE,DELETE)
      • SYNTAXES
      • DATABASE TRIGGERS
      • ROW LEVEL TRIGGERS
      • RAISE_APPLICATION_ERROR
      • Q)WRITE A TRIGGER STOP ALL DML OPERATIONS ON THURS...
      • Q)WRITE A TRIGGER TO STOP ALL DML OPERATIONS BETWE...
      • Examples on Triggers
      • Syntax to write a Trigger
      • We can fire the Triggers in two Levels:
      • PARTS OF TRIGGER
      • TRIGGERS
      • EXAMPLE for COMBINATION OF PACKAGE WITH FUNCTION A...
      • DATA MANIPULATION LANGUASGE
      • DATA TYPES IN PL/SQL
      • SQL VS PL/SQL
      • GLOBAL VARIABLES
      • EXAMPLE ON PROCEDURE OVERLOADING
      • EXAMPLE ON FUNCTION OVERLOADING
      • FUNCTION OVERLOADING
      • Some of the Builtin Packages Stored in the Oracle ...
      • What Are the Benefits of Packages?
      • Q)WHAT IS DATA DICTIONARY TABLE?
      • SYNTAXES IN SQL
      • Q)WRITE A PACKAGE TO DISPLAY THE EMPLOYEE DETAILS ...
      • PACKAGE EXAMPLE 1
      • PACKAGES
      • DDL COMMAND :ALTER
      • SOME IMPORTANT COMMANDS
      • STEPS TO ENTER INTO ORACLE DATABASE
      • PROGRAMS ON PROCEDURES
      • PROGRAMS ON FUNCTIONS:
      • WRITE A FUNCTION TO ADD TWO NUMBERS:
      • FUNCTIONS
      • Rules For Making a Table
      • DATA DEFINITION LANGUAGE
      • MISCELLANEOUS DATA TYPES
      • DIFFERENCE BETWEEN CHAR(SIZE) AND VARCHAR2(SIZE)
      • DATA TYPES IN ORACLE
      • SQL
      • RESPONSIBILITIES & DUTIES OF DATABASE DEVELOPER
      • SUB PROGRAMS
      • EXAMPLE PROGRAM USING IMPLICIT CURSOR
      • PROCEDURES
      • PROCEDURE VS ANANYMOUS BLOCKS
      • practise the queries given in the following link
      • SQL QUERIES
      • PROGRAMS ON CURSORS
      • USING FOR LOOP FETCH EMPLOYEE DETAILS FROM EMP TABLE
      • Q)WRITE A PL/SQL BLOCK TO UPDATE THE COMMISSION OF...
      • ADVANTAGES OF CURSORS USING FOR LOOP
      • Q)WRITE A PL/SQL BLOCK DISPLAY MAX SAL EMPLOYEE N...
      • Q)WRITE  A PL/SQL BLOCK DISPLAY THE MAX SAL AND M...
      • Q)WRITE A PL/SQL BLOCK DISPLAY THE MAX SAL AND MI...
      • PL/SQL PROGRAM
      • PL/SQL PROGRAMS
      • PL/SQL PROGRAM ON CURSOR AND ITS ATTRIBUTES
      • PL/SQL PROGRAM USING CURSOR AND ITS ATTRIBUTES
      • PROGRAMS ON PL/SQL CURSORS
      • SQL QUERIES WITH TABLE
      • PL/SQL CURSORS
      • FREEDOM251 BOOK ONLINE
      • IMPORTANT SQL QUERIES
      • IMPORTANT SQL queries
      • Rs.251 smartphone registration starts at 6 am on 1...
      • some important queries
      • SQL QUERIES USING DECODE
      • USER DEFINED EXCEPTIONS
      • EXAMPLE ON PRAGMA EXCEPTION_INIT BASED ON FOREIGN ...
      • EXAMPLES ON PRAGMA EXCEPTION_INIT
      • ORA-01400 EXAMPLE
      • ORA-01722: invalid number
      • UNNAMED SYSTEM EXCEPTIONS
      • INVALID_NUMBER EXAMPLE
      • TO_MANY_ROWS EXAMPLE
      • --value_error example
      • DIFFERENCE BETWEEN IN AND EXIST?
      • RAISE_APPLICATION_ERROR EXAMPLE
      • GENERAL SYNTAX TO USE RAISE_APLLICATION_ERROR() PR...
      • ZERO DIVIDE EXAMPLE
      • PROCEDURE EXAMPLE
    • ►  January (2)
  • ►  2015 (25)
    • ►  September (16)
    • ►  August (6)
    • ►  July (2)
    • ►  May (1)

About Me

Tech Praveen
View my complete profile
Awesome Inc. theme. Powered by Blogger.