Analytic functions and SQL model clause comes to mind... Gints On 2012. gada 29. maijs, at 16:40, Andrew Kerber <andrew.kerber@xxxxxxxxx> wrote: > (skipped) a rich report writing capability. I had used a > fairly obscure language called CCL (Cerner Command Language), that had a > lot of nice reporting capabilites, including really useful looping and > conditional statements within the report writing, and SQL is comparatively > crude for such -- //www.freelists.org/webpage/oracle-l