Learning Database by Example

27th Example - Explicit Cursor on PL/SQL

Cursor is part of a block of PL/SQL that references to one or several tables in the database. In the PL/SQL there are two types of cursors ...

In the previous module has been described on table-based record. At this time will be explained about the cursor-based record. In contrast ...

After various examples of PL/SQL block is given, let's try an example PL/SQL block through interaction at the tables in the database. A...

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

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

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

On an assessment will be obtained many different values . Those values can be calculated mean values . The average value ...

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

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

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