SQL PL/SQL Examples, Tutorials and Articles

Oracle 11g offers a new twist on triggers, the compound trigger, a trigger than can act both before and after an update, insert or delete has occurred. This makes possible the abilty in one trigger to perform processing similar to a stored procedure without having to write such a procedure to call ...

1. Introduction

Oracle provides Export and Import utilities for the transfer of data from one database to another. It enables writing of data i.e. Export of one database into Operating system files in binary format. These OS files in binary format can only be traced by IMPORT utility ...

1. Overview

The article describes the SQL injection attacks on applications. It demonstrates the code exploitation, ways of rectification and code designing recommendations.

2. Introduction

SQL injection refers to the attack on the applications which have ...

1. Introduction

In the last article, we simulated the attack of simulation of SQL Injection in Oracle. In the current article, we shall see the remedies of SQL Injection, code recommendations, and guidelines to avoid malicious attack on applications.

2. Using invoker’s ...

1. Overview

In the last article, we saw through the stages involved in a Database design. These stages were the categories where the effort involved can be modularised and cumulatively integrated at start of each stage.

Now there are other logical concepts required in logical ...

1. Overview of Database Design basics

An application skeleton consists of Data and Process. Both are mutually dependent on each other. Even a slightest weakness in any of the two can end up in application defects. In the article, we shall discuss the Data side of an application. We shall ...

1. Introduction

Nested Tables or PL/SQL tables are persistent form of collections, which are used to store arbitrary number of elements. Unlike the key-value pair, here each element is identified by a sequential number, which is maintained by Oracle server.


The ...

1. Overview

A collection is a group of elements arranged in a defined order, where each one of them can be accessed through its index. The most common forms of collections are arrays, maps or lists. In current version of programming languages, almost all of them support the use of collections. ...

1. Introduction

VARRAY is the third form of collection available in Oracle, which stands for “Variable sized Arrays”. It is ordered set of fixed number of homogeneous elements, which is available in both SQL and PL/SQL. They can be physically stored in database as schema objects. ...