Here you will get plsql programs to print patterns of stars, numbers and alphabets. Pattern 1:
Here you will get plsql program to find greatest of three numbers. Output a=10 b=12 c=5 b is greatest
In this tutorial you will learn about pl/sql online compiler that will let you run pl/sql programs online. Few days back I was writing plsql programs to share on this blog. There was no compiler installed on my system to test these programs. So I thought to run them quickly using online compiler. I found… Read More »
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, where n is total digits in number. For example 407 is armstrong number as 43 + 03 + 73 = 64 + 0 + 343… Read More »
Here you will get pl/sql program to swap two numbers with and without using temporary variable. Method 1: Using Temporary Variable Output before swapping: a=5 b=10 after swapping: a=10 b=5 Method 2: Without Using Temporary Variable
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 not palindrome. Pl/SQL Program for Palindrome Number Output number is palindrome Comment below if you have any queries regarding above palindrome program in pl sql.
Here you will learn about difference between SQL and PL/SQL. SQL and PL/SQL are two popular database technologies. These two topics are very frequently asked in database interviews. In this article I have shared the key differences between these two technologies. Also Read: PL/SQL Interview Questions and Answers Image Source Difference between SQL and PL/SQL S.… Read More »
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 this function to extract character by character from string in reverse order and concatenate it previous extracted character. || is used to concatenate string. In this way string… Read More »