priya

Function: The main purpose of a PL/SQL function is generally to compute and return a single value. A function has a return type in its specification and must return a value specified in that type. Procedure: A procedure does not have a return type and should not return any value but it can have a … Read more

PL/SQL uses BLOCK structure as its basic structure. Each PL/SQL program consists of SQL and PL/SQL statement which form a PL/SQL block. PL/SQL block contains 3 sections. The Declaration Section (optional) The Execution Section (mandatory) The Exception handling Section (optional) The basic structure of a PL/SQL (Procedural Language/Structured Query Language) block consists of three sections: … Read more

There are two types of datatypes in PL/SQL: Scalar datatypes Example are NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN etc. Composite datatypes Example are RECORD, TABLE etc. PL/SQL (Procedural Language/Structured Query Language) is an extension of SQL that is used to integrate procedural constructs with SQL statements. In PL/SQL, there are several data types available. Some … Read more

Objects of type tables are called PL/SQL tables that are modeled as database table. We can also say that PL/SQL tables are a way to providing arrays. Arrays are like temporary tables in memory that are processed very quickly. PL/SQL tables are used to move bulk data. They simplifies moving collections of data. In PL/SQL, … Read more

A list of some notable characteristics: PL/SQL is a block-structured language. It is portable to all environments that support Oracle. PL/SQL is integrated with the Oracle data dictionary. Stored procedures help better sharing of application PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation’s procedural language extension for SQL. The most important characteristics of PL/SQL include: … Read more