## Examples of SQL used to identify "poorly performing" SQL statements.

   DECLARE
	deptno		scott.dept.deptno%TYPE;
	deptname	scott.dept.dept_name%TYPE;
	emp_rec		scott.emp%ROWTYPE;

	Cursor C1 is select * from sales;
	sales_rec	C1%ROWTYPE;

	Type dept_rec is Record
	 ( deptno	scott.dept.deptno%TYPE,
	   dname	scott.dept.dept_name%TYPE );

	New_Emp		boolean	  := FALSE;
	Max_Emp		number	  constant:= 999999;
	Nxt_Emp		positive  := 1;
   BEGIN
	.
	.
   END;
