what are the SQL REPORTING COMMANDS in Oracle sql

Question

please let me know the list of SQL REPORTING COMMANDS in Oracle sql

Answer 1

1. How to set the title in the top of the table?
   A. ttitle on;
   ttitle 'employee reports';

2. How to off the ttitle?
   A. ttitle off;

3. How to set the title in the left side?
   A. ttitle left 'employee reports' skip left;

4. How to set the title in the center?
   A. ttitle center 'employee reports' skip center;

5. How to set the title in the right side?
   A. ttitle right 'employee reports' skip right;

6. How to set the title in the bottom of the table?
   A. btitle on;
   btitle 'End of the report'

7. How to off the btitle?
   A. btitle off;

8. How to change the column name?
   A. column empno heading 'no';

9. How to change the salary format?
   A. column sal heading 'salary' format $9,999.99;

10. How to clear column heading?
    A. column empno clear;

11. How to break the deptno?
    A. break on deptno;

12. How to clear the break command?
    A. clear breaks; [it clears all the break command]
    clear breaks on deptno;