Learning Database by Example

13th Example - EXCEPTION on PL/SQL

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

FOR looping operator in PL/SQL block has a variation that is capable of processing inverted . If the previous operator FOR loopi...

Other operators that can be used in PL / SQL block for looping is FOR. Here is an example of using the block operator FOR on PL/SQL block : ...

Besides being able to perform the selection operation / condition , PL/SQL is able to perform operations iteration / looping...

Many programs that utilize odd even checking to solve various problems . Checking odd even in the PL/SQL block can be done by us...

CASE WHEN is another types of selection operator rather than IF in PL/SQL block . Here is an example of PL/SQL block that has the ...

PL / SQL is a reliable programming language . AS well as other programming languages , PL / SQL also able to perform the selection ...