packagesinoracleplsql

                                                 Packages in Oracle Pl/Sql

 What is Packages?

      The collection of Procedures, variables, functions, cursors and types etc. is called packages.

      The related Procedures and functions are grouped in to single unit is called package.

      Ex of package: The banking sector has multiple divisions such as Credit card, Personal loan, 
                                 Home loan, Car loan, Insurance etc...

Benefits of creating packages?

      a> It is easy to manage. If any changes required to make in Credit card function then no need to
           alter other divisions. Changes in Credit card division is alone fine.

     b> It supports overloading. In package, we can define one or more procedures or functions in
          same name with different parameters.

     c> Package supports ID. By default procedures and functions is public so that anyone can be
          accessed anywhere.
          Inside the package, we can make some procedures and functions as public or private.
          Public members can be accessed from anywhere but private members can be accessed within
          the package.

     d> It improves performance. For ex. If first time we call pgm A procedure inside a package the whole package will be loaded in to memory. In next time if we are calling another member

Comments

Post a Comment

Popular posts from this blog

Decode function in Oracle pl/sql

Image
DECODE function in Oracle pl/sql As part of Oracle pl sql training , we will see this DECODE function in Oracle plsql. a> This DECODE function is available in Oracle plsql. b> This function is not available in MySQL and SQl server. DECODE syntax : SELECT DECODE ("Column_name", "search_value_1","result_1",                                                                "search_value_2","result_2",                                                                "search_value_3","result_3"                                             ...
Read more

SUBSTR function in Oracle pl/sql 

Image
SUBSTR function in Oracle Pl Sql In real time projects the requirement might come like to extract the length of data from the particular data. In this blog, we will see how we can execute this requirement through Oracle pl sql by using Oracle/PLSQL SUBSTR function.   Syntax of SUBSTR function in Oracle PL SQL is: SUBSTR( string, starting_position [, Total length of the data ] ) Parameters of SUBSTR string Input data which we are going to use for extraction process. starting position It denotes the starting position of length of the data. The position of the string will always start from 1. length Optional. It denotes the length of the character to extract. If this parameter is not given, then the SUBSTR function will return the entire string from the starting position which we given in syntax. The SUBSTR function is used to returns a string value. If length of the data is a negative number, then the SUBSTR function will return a NULL value. Rule of...
Read more

StoredprocedureinOracleplsql

​                                                 Learn Stored procedure concept in Oracle plsql Here in this blog just we are going to see stored procedure concept in Oracle plsql. We will include further topics in Oracle plsql training in separate blogs. 1. Stored procedure is also called as PL/SQL block 2.   Stored procedure receive input in the form of parameters and performs some task and it may or may not returns a value. 3.   Procedures are created to perform one or more DML operations over database.     (Ex: To create one or more DML operation (Insert or Delete or update) over database, we are creating        Stored procedure) SYNTAX for Stored procedure: CR...
Read more