search
  • Home
    •
  • Learn
    •
  • Download
    •
    Get Started
  • Quick Start arrow right
  • Installation arrow right
    • SQL COMMANDS
  • DDL arrow right
  • DML arrow right
  • DCL arrow right
  • DQL arrow right
  • TCL arrow right
    • CONSTRAINTS
    NOT NULL
  • arrow right
    • PRIMARY KEY
  • arrow right
    • FOREIGN KEY
  • arrow right
    • CHECK
  • arrow right
    • DEFAULT
  • arrow right
    • SQL FUNCTIONS
    DATE FUNCTION
  • arrow right
    • STRING FUNCTION
  • arrow right
    • NUMERIC FUNCTION
  • arrow right
    • PL/SQL
    INTRODUCTION
  • arrow right
    • ADVANTAGES OF PL/SQL
  • arrow rightDATATYPES AND DECLARATION
    • VARIABLES AND CONSTANTS
  • arrow right
    • CONTROL STATEMENTS
  • arrow right
    • ITERAIVE CONTROL
  • arrow right
    • CONDITIONAL CONTROL
  • arrow right
    • ERROR HANDLING
    OVERVIEW OF ERROR HANDLING
  • arrow right
    • EXCEPTION TYPES
  • arrow rightDATATYPES AND DECLARATION
    • SUBPROGRAMS
    INTRODUCTION
  • arrow right
    • TYPES
  • arrow right
    • ADVANTAGES
  • arrow right
    • PROCEDURE
  • arrow right
    • FUNCTIONS
  • arrow right
    • PACKAGES
  • arrow right
    • DATABASE TRIGGERS
  • INTRODUCTION arrow right
  • USE arrow right
  • PARTS arrow right
  • TYPES arrow right
  • SYNTAX arrow right
  • ERROR WITH TRIGGERS arrow right

    • ADVANTAGES AND DISADVANTAGES OF PL/SQL

    ADVANTAGES:-

    Pl/sql is a completely porrtable,high permormance transaction processing language.whic offers the following advantages.

    PL/SQL has these advantages:

    1.Tight Integration with SQL.

    2.High Performance.

    3.High Productivity.

    4.Portability.

    5.Scalability.

    6.Manageability.

    7.Support for Object-Oriented Programming.
    DISADVANTAGES:-

    Disadvantages of PL/SQL – PL/SQL is a specialized programming language, which may require developers to invest time and effort in learning and mastering the language. Potentially leading to security vulnerabilities – PL/SQL code can introduce security vulnerabilities if it is not properly designed and implemented. Being prone to errors – PL/SQL code can be prone to errors, particularly if it is complex or poorly written. Being resource-intensive – PL/SQL code can be resource-intensive, which can impact the performance and scalability of database applications.Pl/sql is a completely porrtable,high permormance transaction processing language.whic offers the following advantages.

    PL/SQL has these disadvantages:



    1.Requiring specialized knowledge:->PL/SQL is a specialized programming language, which may require developers to invest time and effort in learning and mastering the language.

    2.Being limited to Oracle databases :-> PL/SQL is specific to Oracle databases, which can limit its use and compatibility with other database management systems.

    3.Potentially leading to security vulnerabilities :->PL/SQL code can introduce security vulnerabilities if it is not properly designed and implemented..

    4.Being prone to errors :->PL/SQL code can be prone to errors, particularly if it is complex or poorly written.

    5.Being resource-intensive:->PL/SQL code can be resource-intensive, which can impact the performance and scalability of database applications.

    DATA TYPES AND DECLARATION

    Every constant and variable has a data type,which specifies a storage format,constraints,and a valid range of values.

    Some commenly used datatypes of pl/sql are:

    *NUMBER
    *CHAR
    *VARCHAR
    *DATE
    *BOOLEAN
    *LONG
    *LONG RAW
    *LOB