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... Read More
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... Read More
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... Read More
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... Read More
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... Read More
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... Read More
2nd highest salary sql Sarfraz Alam March 08, 2018 Here i have posted three methods to find second highest salary of an employee. select max(salary) from employee where salary not in(se... Read More