The main component of SQL-AG is its pre-compiler that is used to generate the code for an aggregate, given its specification in SQL-AG.
Figure 3.1: Creating stored PL/SQL procedure
Figure 3.1 gives a general idea of how the tool works. The user writes
the aggregate using SQL-AG, the specification language. Using the pre-compiler,
a PL/SQL procedure is generated in the file generated.sql. Then
either using sqlplus 
or svrmgrl
a PL/SQL stored procedure is created. This procedure could then be used in any
further PL/SQL program.