Tutorialspoint.dev
Welcome To Tutorialspoint.dev
Officially launched 18th May 2019
SQL SQL-PL/SQL SQL

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...
DBMS SQL SQL-PL/SQL

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...
DBMS School Programming SQL

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...
DBMS SQL pattern-printing

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 : * ** *** **** ***** *...
DBMS SQL SQL-PL/SQL

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 SQL-PL/SQL SQL

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...
DBMS SQL SQL-PL/SQL

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...
SQL SQL-PL/SQL SQL

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 ...
DBMS SQL SQL-PL/SQL

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...
SQL SQL-PL/SQL triangular-number

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

Subscribe to Our Newsletter