Ashish Awasthi's Blog

PL/SQL Function is same as PL/SQL Procedure, The only difference is that function must return a value and a procedure may or may not retur...

Previously I have posted about PL/SQL Block structure , A piece of code that is organized in a properly defined sequence is called a bloc...

An error that occurs during execution of the program is called exception, Like other programming languages, PL/SQL offers a way to catch t...

PL/SQL FOR loop is used when we need to execute set of statements for the specific number of times and loop operates between the start and...

PL/SQL WHILE loop is used to execute statements as long as given condition is true and the condition is checked at the beginning of each i...

In PL/SQL Basic Loop all statements inside the block are executed at least once before loop termination, Basic loop encloses statement bet...

Loops are used to repeat execution of a statement or a set of statements multiple times on base of a condition or expression EXIT and EXI...

Like real life in programming sometimes we need to execute some code on a specific condition, PL/SQL CASE statement allows us to execute a...

Like other programming languages, PL/SQL supports decision making statements, These statements are also called conditional statement Bas...

A variable in any programming language is the name of space where values are stored and controlled by our code/program We can not use r...

PL/SQL is highly structured language and it's program units are written in the block of code, In this tutorial, we'll learn about ...

PL/SQL is developed by Oracle Corporation to increase/enhance capabilities of SQL, PL/SQL stands for P rocedural L anguage extension to SQ...

I hope all of you'll be familiar with Oracle SQL Developer tool , A tool used by database developers to perform DB related tasks effic...