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

By: Prem Tiwari | Last Updated: | In: 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

By: Prem Tiwari | Last Updated: | In: 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

By: Editorial Staff | Last Updated: | In: 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

By: Editorial Staff | Last Updated: | In: 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

By: Editorial Staff | Last Updated: | In: 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

By: Editorial Staff | Last Updated: | In: 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

By: Editorial Staff | Last Updated: | In: 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

By: Editorial Staff | Last Updated: | In: 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

By: Editorial Staff | Last Updated: | In: 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 …