1
Download SQL*Plus User's Guide and Reference
Transcript
Clarifying Your Report with Spacing and Summary Lines DEPARTMENT_ID ------------20 ************* sum JOB_ID LAST_NAME SALARY ---------- ------------------------- ---------MK_MAN Hartstein 13000 ********** ---------13000 DEPARTMENT_ID JOB_ID LAST_NAME SALARY ------------- ---------- ------------------------- ---------80 SA_MAN Russell 14000 Partners 13500 ************* ********** sum ---------27500 DEPARTMENT_ID JOB_ID LAST_NAME SALARY ------------- ---------- ------------------------- ---------90 AD_PRES King 24000 AD_VP Kochhar De Haan 17000 17000 ************* ********** sum ---------58000 6 rows selected. To compute the sum of salaries for departments 10 and 20 without printing the compute label: COLUMN DUMMY NOPRINT; COMPUTE SUM OF SALARY ON DUMMY; BREAK ON DUMMY SKIP 1; SELECT DEPARTMENT_ID DUMMY,DEPARTMENT_ID, LAST_NAME, SALARY FROM EMP_DETAILS_VIEW WHERE SALARY>12000 ORDER BY DEPARTMENT_ID; DEPARTMENT_ID LAST_NAME SALARY ------------- ------------------------- ---------20 Hartstein 13000 ---------13000 80 Russell 80 Partners 14000 13500 ---------27500 90 King 90 Kochhar 90 De Haan 24000 17000 17000 ---------58000 6 rows selected. To compute the salaries just at the end of the report: 6-14 SQL*Plus User's Guide and Reference
