Learning Database by Example

28th Example - Implicit Cursor on PL/SQL

Implicit cursor is a cursor that was made on the contents of PL/SQL block and can only do 1 unit record processing. Unlike explicit cursors...

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