\begin{sql}
  \gray CREATE OR REPLACE PROCEDURE list\_big\_cities\\
  \gray     (the\_country country.code\%TYPE) \\
  \gray IS \\
  \gray BEGIN \\
  \> FOR {\magenta the\_city} IN \\
  \>\>(\> SELECT {\blue Name} \\
  \>\>\> FROM City \\
  \>\>\> WHERE Country = the\_country \\
  \>\>\> AND Population > 1000000 )\\
  \> LOOP \\
  \>\>  dbms_output.put_line({\magenta the\_city}.{\blue Name}); \\
  \> END LOOP; \\
  \gray END; \\
  \gray /\end{sql}
