sqlparser

CREATE PROCEDURE humanresources.Uspgetallemployees  
AS  
BEGIN  
  SELECT lastname, 
         firstname, 
         jobtitle, 
         department  
  FROM   humanresources.vemployeedepartment;  
END  

sqlparser

CREATE PROCEDURE humanresources.Uspgetallemployees  
AS  
   SELECT lastname, 
          firstname, 
          jobtitle, 
          department  
   FROM   humanresources.vemployeedepartment;  

sqlparser

SELECT 
  lastname, 
  firstname, 
  jobtitle, 
  department  
FROM   humanresources.vemployeedepartment; 

sqlparser

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO

sqlparser

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

sqlparser

PROCEDURE Update_Student_GPA (nSSN IN     number)

IS

sqlparser

PROCEDURE Update_Student_GPA (nSSN IN     number)
IS

  <declaration>
  <declaration>

BEGIN
  <statements>;
END Update_Student_GPA;

sqlparser

EXCEPTION
  WHEN NO_DATA_FOUND THEN
       <statements>

  WHEN TOO_MANY_ROWS THEN
       <statements>

  WHEN OTHERS THEN
       <statements>

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

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