top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

what are the SQL REPORTING COMMANDS in Oracle sql

+3 votes
81 views

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

posted Sep 15, 2014 by Arun Gowda

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+2 votes
  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;

answer Sep 15, 2014 by Suchithra
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...