Welcome To Tutorialspoint.dev
Officially launched 18th May 2019

# 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 &#x2013; 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 &#x2013; 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 &#x2013; 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 &#x2013; 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 &#x2013; PL/SQL introduction In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare ...