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