Learning Database by Example

Celsius to Fahrenheit Conversion on Oracle PL/SQL

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

In this example will be shown the error handling on PL/SQL block in case we have made an error in logic. Error handling in PL/SQL blo...

Other looping operator on the PL/SQL block is a WHILE . As with any other iteration operator , WHILE operator able to process ...