Total: 32 Posts
Posts of Category: PL/SQL
Whenever you try to execute an SQL statement, Oracle processes it in a separate memory zone called as ‘Context Area’. It contains information regarding information retrieved from database tables...Learn More
In the previous tutorials, we have learnt about the variables in PL/SQL. In almost every programming language, we need to do mathematical calculations and other such related operations. To...Learn More
**Introduction to PL/SQL Programming**
PL/SQL Basics – Introduction to PL/SQL Programming
PL/SQL stands for Procedural Language/Structured Query Language. It is an extension of Structured Query Language (...Learn More
**PL/SQL Data Types**
In the previous tutorial, you learnt about how to write and run Hello World program in PL/SQL programming language. In this tutorial you will learn about various data types used in PL/SQL...Learn More
PL/SQL Program to Check Number is Odd or Even
Here you will get pl/sql program to check number is odd or even.
A number is even if it is completely divisible by 2 otherwise it is odd.
PL/SQL Program to Check Nu...Learn More
PL/SQL Program to Find Factorial of a Number
Here you will get pl/sql program to find factorial of a number.
We can calculate factorial of a number by multiplying it with all the numbers below it.
For example f...Learn More
PL/SQL Program To Add Two Numbers
In the previous tutorial we have learnt much about PL/SQL variables, operators, data types and other such fundamental topics. Let us get into real programming now onwards.
PL/SQL Program to Reverse a String
Here you will get pl/sql program to reverse a string.
The substr() function returns a part of string. It has following syntax.
substr(string, position, length);
We will use th...Learn More
Pl/SQL Program for Palindrome Number
Here you will get pl/sql program for palindrome number.
A number is called palindrome number if its reverse is equal to itself. For example 12321 is palindrome while 123 is ...Learn More
PL/SQL Program to Swap two Numbers
Here you will get pl/sql program to swap two numbers with and without using temporary variable.
Method 1: Using Temporary Variable
PL/SQL Program for Armstrong Number
Here you will get pl/sql program for armstrong number.
A number is said to be an armstrong number if sum of its digits raised to the power n is equal to number itself, w...Learn More
A subprogram is a module or a small unit/part of a program that performs a particular task. In modular programming, a program can optionally consist of multiple subprograms.
Note: A schema le...Learn More