Interesting Patterns : PLSQL Sarfraz Alam August 02, 2018 declare total_counter1 number :=&10; total_counter2 number :=&10; i number :=1; j number :=1; begin <<outerloop&g... Read More
Cursor Expressions in PL/SQL Sarfraz Alam July 09, 2018 A cursor expression, denoted by the CURSOR operator, returns a nested cursor from within a query. Each row in the result set of this neste... 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
sql queries for practise Sarfraz Alam June 20, 2018 I have arranged some basic sql queries that will help you to sort out basic query related problems and build your concept also. Here emp ... 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