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...
