Learning Database by Example

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

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

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

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

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

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