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 ...

Before Oracle Database 12c, values with PL/SQL-only data types (for example, BOOLEAN, associative array, and record) could not be bound from client programs (OCI or JDBC) or from static and native ...

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 ...

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 ...

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 ...