priya

Modularity, extensibility, reusability, Maintainability and one time compilation. Stored procedures in PL/SQL offer several advantages: Modularity and Reusability: Stored procedures allow you to encapsulate a set of SQL statements into a single named unit, making the code modular and reusable. Once created, a stored procedure can be called from different parts of a program or … Read more

There are two way to execute a stored procedure. From the SQL prompt, write EXECUTE or EXEC followed by procedure_name. EXECUTE or [EXEC] procedure_name; Simply use the procedure name procedure_name; In PL/SQL, you can execute a stored procedure using the EXECUTE statement or its shorthand notation EXEC. Here is the syntax: EXECUTE procedure_name(parameters); or EXEC … Read more

The DROP PACKAGE command is used to delete a package. In PL/SQL, the correct command to delete a package is: DROP PACKAGE package_name; Replace package_name with the actual name of the package you want to delete. The DROP PACKAGE statement is used to remove a PL/SQL package from the database.

PL/SQL packages have the following two parts: Specification part: It specifies the part where the interface to the application is defined. Body part: This part specifies where the implementation of the specification is defined. In PL/SQL, a package consists of two parts: Specification: This is the interface to the package. It declares the types, variables, … Read more

A PL/SQL package can be specified as a file that groups functions, cursors, stored procedures, and variables in one place. In PL/SQL, a package is a database object that groups related functions, procedures, variables, and other constructs together as a single, named unit. It is a way to organize and modularize code in the Oracle … Read more