ORACLE: Group by clause
Sarfraz Alam
August 18, 2018
Group By clause The SQL GROUP BY Clause is used along with the group functions to retrieve data grouped according to one or more col...
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Saturday, 18 August 2018
Wednesday, 20 June 2018
PL/SQL Cursors
Sarfraz Alam
June 20, 2018
what is cursor in PL/SQL? A Cursor is a pointer to this context area. Oracle creates context area for processing an SQL statement which ...
PL/SQL Cursor examples
Sarfraz Alam
June 20, 2018
example 1 - In this example we use cursor to fetch the name of the employee whose department is IM. declare temp varchar2(20); curso...
Sunday, 25 March 2018
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 ...
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...
Thursday, 15 March 2018
Age calculator
Sarfraz Alam
March 15, 2018
I have created the age calculator using PLSQL, In this user input the date of birth and the age is shown as result. A function names age...
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...
Thursday, 8 March 2018
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...
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 ...
Monday, 8 January 2018
Find second largest value with subquery
Sarfraz Alam
January 08, 2018
The way to approach this is to first find the largest value (easy to do with MAX), exclude that value from the data set being evaluated, ...
Thursday, 10 November 2016
Basic PL/SQL programs
Sarfraz Alam
November 10, 2016
Some Basic PL/SQL programs Print your name using PL SQL block. Declare mes...
