Cursors in PL/SQL

Cursor in SQL To execute SQL statements, a work area is used by the Oracle engine for its internal processing and storing the information. This work area is private t...

Sum Of Two Numbers in PL/SQL

Prerequisite – PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare...

Factorial of a number in PL/SQL

Prerequisite – PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare...

Print Patterns in PL/SQL

You have given a number n then you have to print number a right-angled pyramid of * Examples: Input : 3 Output : * ** *** Input : 7 Output : * ** *** **** ***** *...

Reverse a number in PL/SQL

Prerequisite – PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare...

SQL Procedures in PL/SQL

PL/SQL is a block-structured language that enables developers to combine the power of SQL with procedural statements. A stored procedure in PL/SQL is nothing but a s...

PL/SQL Introduction

PL/SQL is a block structured language that enables developers to combine the power of SQL with procedural statements.All the statements of a block are passed to oracl...

GCD of two numbers in PL/SQL

Prerequisite – PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare ...

Decision Making in PL/SQL (if-then , if-then-else, Nested if-then, if-then-elsif-then-else )

There come situations in real life when we need to make some decisions and based on these decisions, we decide what should we do next. Similar situations arise in pro...

Centered triangular number in PL/SQL

Prerequisite – PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare ...