APEX_PUBLIC_USER Print…Logout
 

Generic Column Report

DNAMEENAMEJOB
ACCOUNTINGCLARKMANAGER
 KINGPRESIDENT
 MILLERCLERK
RESEARCHADAMSCLERK
 FORDANALYST
 JONESMANAGER
 SCOTTANALYST
SALESALLENSALESMAN
 BLAKEMANAGER
 JAMESCLERK
 MARTINSALESMAN
 WARDSALESMAN
OPERATIONSKOVACSANALYST
 SMITHCLERK
 TURNERSALESMAN
1 - 15

Row Template with rowspan I

DNAMEENAMEJOB
ACCOUNTING CLARK MANAGER
KING PRESIDENT
MILLER CLERK
RESEARCH ADAMS CLERK
FORD ANALYST
JONES MANAGER
SCOTT ANALYST
SALES ALLEN SALESMAN
BLAKE MANAGER
JAMES CLERK
MARTIN SALESMAN
WARD SALESMAN
OPERATIONS KOVACS ANALYST
SMITH CLERK
TURNER SALESMAN
1 - 15

Report SQL I

Named Column Template I

Row Template with rowspan II

DNAMEENAMEJOB
ACCOUNTING CLARK MANAGER
KING PRESIDENT
MILLER CLERK
RESEARCH ADAMS CLERK
FORD ANALYST
JONES MANAGER
SCOTT ANALYST
SALES ALLEN SALESMAN
BLAKE MANAGER
JAMES CLERK
MARTIN SALESMAN
WARD SALESMAN
OPERATIONS KOVACS ANALYST
SMITH CLERK
TURNER SALESMAN
1 - 15

Report SQL II

Named Column Template II

Two Break Columns: Generic Column Template

DnameJobEname
ACCOUNTINGCLERKMILLER
 MANAGERCLARK
 PRESIDENTKING
RESEARCHANALYSTFORD
  SCOTT
 CLERKADAMS
 MANAGERJONES
SALESCLERKJAMES
 MANAGERBLAKE
 SALESMANALLEN
  MARTIN
  WARD
OPERATIONSANALYSTKOVACS
 CLERKSMITH
 SALESMANTURNER
1 - 15
 

Two Break Columns: Named Column Template

DnameJobEname
ACCOUNTING CLERK MILLER
MANAGER CLARK
PRESIDENT KING
RESEARCH ANALYST FORD
SCOTT
CLERK ADAMS
MANAGER JONES
SALES CLERK JAMES
MANAGER BLAKE
SALESMAN ALLEN
MARTIN
WARD
OPERATIONS ANALYST KOVACS
CLERK SMITH
SALESMAN TURNER
1 - 15

Report SQL III

Named Column Template III