SELECT [ { DISTINCT | UNIQUE } | ALL ]
  { * | select_item [[,] select_item ]... }
    [ BULK COLLECT ] INTO
      { variable_name [ [,] variable_name ]... | record_name }
        FROM { table_reference | [ THE ] ( subquery ) } [ alias ]
          [ { table_reference | [ THE ] ( subquery ) } [ alias ] ]...
            rest-of-statement ;