• The Oracle PL/SQL WITH Clause
  in Oracle > DB 11g with clause factoring oracle plsql psoug subquery with
• 10.5 Specifying Partitions :: Chapter 10. Partitioning :: Mastering Oracle SQL :: SQL :: eTutorials.org
  SUBPARTITION clause to focus on a single subpartition of the table.
  in Oracle > DB 11g with 11g 11gr2 clause focus oracle partition partition_extension single subpartition table

clause from all users