Diksha IT Training Centre

  Package in Oracle and it’s Advantage in PL/SQL Program. Hello Everyone, In my Previous Blogs I Discussed about Stored Procedures, Stored Functions, Cursor etc. Today we will discuss about Oracle Packages. Oracle Package plays very important role in PL/SQL program . Package we can say collection of Procedures , Functions , Cursor etc . In another word we can say A package is a schema object that groups logically related PL/SQL types, variables, and subprograms.   Packages usually have two parts: Package Specification and Package Body, Sometimes the body is not required .The specification is the main interface to the package. It declares the types, variables, constants, exceptions, cursors, and subprograms that can be referenced from outside the package. The body mainly defines the queries for the cursors and the code for the subprograms. PL/SQL Package is very important in Database and as mentioned above it contains multiple procedures , Functions, variables , cursors etc

                Stored Function in Oracle Database and it’s benefit. Hello Everyone, In my previous blogs we discussed about stored procedures and its attributes and benefits of using Stored Procedure in Databases. Today we will discuss about Stored Function. Stored Function is also named block like Stored Procedure a stored function is a set of PL/SQL statements you can call by name. Stored functions are very similar to procedures, except that a function returns a value. Stored functions must return a value whether condition is true or false, but in Stored procedure value should return only when condition is true.   Stored function only return one value, whereas in stored procedure if condition is true it can give you multiple record as well as multiple transaction. Stored Function can be used in Procedures, Packages as well as into select statement, but procedure can’t be called in select statement. Both Stored Procedures and functions are stored in a compact compiled form. When

  Object-Oriented Programming Concept and Oracle PL/SQL   Hello Everyone, Today I will discuss about the concept of Object-Oriented programming Concept. In object Oriented Programming (OOP) An Object is the key component of Object-oriented programming. An Object may contain data (fields or variables) or code (methods or procedures). The creation of these objects is based on a Class. There are four Types of Principle in Object Oriented Programming. 1. Inheritance: Inheritance is most important feature of OOP as it inherit the property of classes and object . In other word we can say Inheritance is the process of creating new classes from base classes where there is a relationship exists. The derived class extends from the base class in order to inherit its properties. Inheritance can be used for reusability purpose. 2. Polymorphism : Polymorphism means data into different form. Polymorphism is the ability of an object to take on many forms. For example : Branch, Branch_detai

  PL/SQL Procedure in Oracle Database and Advantages of Stored Procedures.   Hello Everyone, Today I will discuss about named Block in PL/SQL that is Stored Procedure However Named block in PL/SQL is Procedure, function, packages, trigger etc that I will cover in next blogs. In my previous Blogs we know about PL/SQL Anonymous Block, Cursors and %TYPE and %ROWTYPE attribute. PL/SQL blocks are of two types Anonymous Block and Named Block . Anonymous Block we already discussed in last blog Let’s Start with Procedure in PL/SQL before that you can go through my previous blog for your reference. Procedure in PL/SQL is database object which is mainly used for reusability in other word Procedure is as subprogram unit/module that performs a particular task. These subprograms are combined to form larger programs. This is basically called the 'Modular design'.Procedures can be invoked by another subprogram or program which is called the calling program. Procedure can be create

              PL/SQL in Oracle with basic Programs. Hello Everyone, Today I will discuss about PL/SQL in Oracle .In Previous Blog we discussed about cursor and anonymous block used in cursor as well as uses of %TYPE and %ROWTYPE attribute. Before starting this topic please go through my below blog. https://dikshaoracletraining.blogspot.com/2020/10/cursor-and-types-of-cursor-in-oracle.html https://dikshaoracletraining.blogspot.com/2020/11/benefits-of-type-and-rowtype-in-oracle.html PL/SQL is basically a Procedural Language in SQL and in PL/SQL we use separate two parts first is Anonymous Block and second is Named Block. The PL/SQL programming language was developed by Oracle Corporation in the late 1980s as procedural extension language for SQL relational database. PL/SQL high-performance transaction-processing language.PL/SQL is completely portable.   PL/SQL provides a built-in, interpreted and OS independent programming environment.   PL/SQL can directly be called from the c