## 24th Example - VARRAY on PL/SQL

June 30, 2013
In the following example will be demonstrated using VARRAY data type. VARRAY is one of the collection types in Oracle Database. The princip...

## 23rd Example - Associative Array (Index-By Table) on PL/SQL

June 28, 2013
In this example we will study the use of arrays in PL/SQL block. Array in PL/SQL block is known as collection types. One of the collection ...

## 22nd Example - Count Area and Circumference of A Circle on PL/SQL

June 26, 2013
In 18 th Lessons, it has been given an example to calculate the area of ​​a circle. The formula to calculate the area of ​​a circle is p r...

## 21st Example - Count the Average and Categorizes on PL/SQL

June 21, 2013
On an assessment will be obtained many different values ​​. Those values ​​can be calculated mean values ​​. The average value ...

## 20th Example - Calculate Employee Salaries on PL/SQL

June 20, 2013
A company has many employees with various status, married and not married. A married employees would get salaries larger than the unmarried ...

## 19th Example - Calculating Parking Fee on PL/SQL

June 19, 2013
At a shopping area usually has a parking facility equipped with automated parking system. Automatic calculation is done by a parking progra...

## 18th Example - Count Area of A Circle on PL/SQL

June 17, 2013
The circle is of mathematical shape that can be found in the real world such as car wheels, the pipe, cable cross-section. Circle has an ar...

## Celsius to Fahrenheit Conversion on Oracle PL/SQL

June 16, 2013
This article will discuss about Celsius to Fahrenheit Conversion on Oracle PL/SQL.  Temperature has a different measurement units such as C...

## 16th Example - Factorial Value on PL/SQL

June 15, 2013
Factorial is one of the techniques in the mathematical sciences . A factorial value of a number is the product of the number (...

## 15th Example - Count the Discount Price on PL/SQL

June 14, 2013
At a store or a supermarket, the payment process is at the cashier. Cashier operator will do scanning of the item code by a barcode reader....

## 14th Example - Calculate Your Age on PL/SQL

June 10, 2013
We have learned the basics of PL/SQL block from the start structured , selection, looping and exception . Let us now try to ma...