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

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