Prime PLSQL
Sarfraz Alam
March 25, 2018
This program will print prime numbers in the given range. the range is given by the user. DECLARE i number(3); j ...
Showing posts with label PL SQL. Show all posts
Showing posts with label PL SQL. Show all posts
Sunday 25 March 2018
Sunday 18 March 2018
patterns in plsql
Sarfraz Alam
March 18, 2018
The following pattern represents P(5) as : * * * * * * * * * * * * * * * Here you can change the value of i to print different...
Friday 16 March 2018
calculator in plsql
Sarfraz Alam
March 16, 2018
I have created a simple calculator using concept of packages and functions in plsql if there is any query you can comment below creat...
Wednesday 14 March 2018
data Insertion PLSQL
Sarfraz Alam
March 14, 2018
PLSQL code to insert values in table In this tutorial i will show you how to insert data in a table by taking input from the u...
Tuesday 13 March 2018
PL/SQL function to view maximum of 3 numbers
Sarfraz Alam
March 13, 2018
In this code the input is given by the user. DECLARE a number := &enter_first_Number; b number := &Enter_second_number...
Monday 12 March 2018
Palindrome PLSQL
Sarfraz Alam
March 12, 2018
PL/SQL code to check input number is palindrome or not DECLARE no integer; dummy integer; temp integer :=0; B...
FACTORIAL PLSQL
Sarfraz Alam
March 12, 2018
PL/SQL code to find factorial of a number entered by user DECLARE num number; factorial number; FUNCTION fact(x number...
PL/SQL fibonacci series
Sarfraz Alam
March 12, 2018
PL/SQL program to generate Fibonacci series DECLARE a number; b number; c number; num number; BEGIN num:=&ent...
Sunday 11 March 2018
PL/SQL Arrays
Sarfraz Alam
March 11, 2018
Declaration In PL/SQL arrays are denoted as VARRAY, which can store a fixed sized sequential characters as per the defined type and rang...
Tuesday 6 March 2018
Even number plsql
Sarfraz Alam
March 06, 2018
PLSQL code to check that the given number is even or not. declare num1 number; BEGIN num1 := &enter_number; --to take input fro...
plsql - Fetch data from a table in oracle sql
Sarfraz Alam
March 06, 2018
DECLARE c_id number; c_name employee.emp_name%type; c_addr employee.emp_address%type; c_sal employee.emp_sal%type; BEGIN ...
