sqlparser

SELECT department_id, 
       Min(salary)  
FROM   employees  
GROUP  BY department_id  

sqlparser

CREATE TABLE datatype  
  (fld0 GENERICTYPE, 
   fld1 CHAR(2), 
   fld3 NCHAR(1)); 

sqlparser

CREATE FUNCTION dbo.isoweek (@DATE datetime) 
RETURNS INT 
WITH EXECUTE AS caller 
AS 
BEGIN 
     DECLARE @ISOweek INT 


     SET @ISOweek= datepart(wk,@DATE)+1 
          -datepart(wk,CAST(datepart(yy,@DATE) AS CHAR(4))+'0104') 

sqlparser

--
-- If the student's grade point average meets the criteria for
-- mandatory academic counseling, add the student's name and social
-- security number to the list.
--
IF (nRealGPA < 1.5) THEN
<statements>

--
-- We also want to consider students who are failing two or more

sqlparser

--
-- For each student returned by the query, add the student's social
-- security number to the PL/SQL table.
--
FOR Students_rec IN Students_cur LOOP
   <statements>
END LOOP;

sqlparser

EXCEPTION
  WHEN NO_DATA_FOUND THEN
       <statements>

  WHEN TOO_MANY_ROWS THEN
       <statements>

  WHEN OTHERS THEN
       <statements>

sqlparser

PROCEDURE Update_Student_GPA (nSSN IN     number)
IS

  <declaration>
  <declaration>

BEGIN
  <statements>;
END Update_Student_GPA;

sqlparser

PROCEDURE Update_Student_GPA (nSSN IN     number)

IS

sqlparser

SET @A = @B 
SET @C = @D 
SET @E = @F 
SET @G = @H 

sqlparser

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO