Example 12-12: SQL query using extended dot notation

SELECT *
  FROM ( SELECT *
           FROM flight_schedule fs
          WHERE fs.Flight.Origin.Location.Longitude.Degrees = 0
            AND TRUNC(departs_at) = '26-APR-2000'
       ORDER BY departs_at )
WHERE ROWNUM <= 1