Write a PL/SQL block to differentiate between CHAR and VARCHAR2 datatype

Prem Tiwari - - PL/SQL


If you are a PL/SQL beginner or want to start learning, then keep your close attention in this tutorial as we are going to share how to write a PL/SQL block to differentiate between CHAR …

Basic PL/SQL Programs With Examples

Prem Tiwari - - PL/SQL


In this section, we will share the list of some basic PL/SQL programs with examples and output. If you are a PL/SQL beginner or want to start learning, then keep your close attention in this …

Pl/SQL program for palindrome number

Editorial Staff - - PL/SQL


PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation’s procedural extension for SQL and the Oracle relational database. It is one of three key programming languages which is only available in Oracle Database. How to find …

PL/SQL program to reverse a string

Editorial Staff - - PL/SQL


PL/SQL is one of three key programming languages which is only available in Oracle Database. PL/SQL program to reverse a string Copy the below PL/SQL program and execute it. In this program, we are going …

Find the Factorial of a number in PL/SQL

Editorial Staff - - PL/SQL


PL/SQL is one of three key programming languages which is only available with the Oracle Database. PL/SQL is a relational database. Copy the below PL/SQL program and execute it. In this program, we are going …

How to add two numbers in PL/SQL

Editorial Staff - - PL/SQL


PL/SQL is one of three key programming languages which is only available with the Oracle Database. PL/SQL is a relational database. Copy the below PL/SQL program and execute it. In this program, we are going …

How to multiply two numbers in PL/SQL

Editorial Staff - - PL/SQL


PL/SQL is one of three key programming languages which is only available with the Oracle Database. PL/SQL is a relational database. How to multiply two numbers in PL/SQL Copy the below PL/SQL program and execute …

Print a star patterns in PL/SQL programming

Editorial Staff - - PL/SQL


PL/SQL is one of three key programming languages which is only available with the Oracle Database. PL/SQL is an relational database. Print a star patterns in PL/SQL programming Copy the below PL/SQL program and execute …

How to reverse a number in PL/SQL

Editorial Staff - - PL/SQL


PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation’s procedural extension for SQL and the Oracle relational database. It is one of three key programming languages which is only available in Oracle Database. PL/SQL is classified …