This is repository for Oracle PL/SQL examples that can be practical for day to day work. Function for returning of random number, based on Oracle PL/SQL DBMS_RANDOM built in package. Function file is ...

In this chapter, we will discuss the cursors in PL/SQL. Oracle creates a memory area, known as the context area, for processing an SQL statement, which contains all the information needed for ...

This chapter describes the PL/SQL interface to the Oracle Cryptographic Toolkit. The PL/SQL procedures and functions are grouped into the following five functional categories: The following functions ...

A novel way of accessing Pl/Sql functions and providing dynamic adaptability using aspect oriented programming Abstract: The need for dynamic adaptability in software is growing, driven in part by the ...

I've got a PL/SQL function that is generating a web page the users can use to manipulate the data in a spreadsheet-like environment.I need to pass this edited data back to the PL/SQL function to ...