Home » SQL & PL/SQL » SQL & PL/SQL » SQL plus report in excel format
SQL plus report in excel format [message #384678] Wed, 04 February 2009 15:29 Go to next message
konark
Messages: 24
Registered: February 2008
Location: Takhsila
Junior Member
I run a sql*plus report whch i want to be outputted to XLS file. But the format is not matching. I am using data->texttocolumns feature of excel , which is manual .

As the headers are coming dynamically from query . i CAN NOT set header off.

So first of all ,
I want to get rid of the first blank line above the hearder.
i want to get rid of the dotted line below header .

PS: I got a thread related to this one , but did not answer my query . So i have made a new thread. Please dont get angry ..
Re: SQL plus report in excel format [message #384681 is a reply to message #384678] Wed, 04 February 2009 18:37 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Post DDL for tables.
Post DML for test data.

Post expected/desired results.

use CUT & PASTE so we can see what you did & how Oracle responded.
Re: SQL plus report in excel format [message #384707 is a reply to message #384681] Wed, 04 February 2009 22:49 Go to previous messageGo to next message
trivendra
Messages: 208
Registered: October 2007
Location: Noida, India
Senior Member
SET HEAD OFF on sqlplus

Thanks
Trivendra
Re: SQL plus report in excel format [message #384720 is a reply to message #384681] Wed, 04 February 2009 23:57 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
BlackSwan wrote on Thu, 05 February 2009 01:37
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Post DDL for tables.
Post DML for test data.

Post expected/desired results.

use CUT & PASTE so we can see what you did & how Oracle responded.


Why do you need DDL for this? The poster made quite clear what he needs: He wants the header-columns, but not the leading blank line, nor the separator line containing the ----

Please stop this back-seat moderating. If people violate posting standards, they will be warned by moderators.
Re: SQL plus report in excel format [message #384725 is a reply to message #384720] Thu, 05 February 2009 00:05 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
SQL> select * from emp;

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
      7369 SMITH      CLERK           7902 17-DEC-80        800                    20
      7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30
      7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30
      7566 JONES      MANAGER         7839 02-APR-81       2975                    20
      7654 MARTIN     SALESMAN        7698 28-SEP-81       1250       1400         30
      7698 BLAKE      MANAGER         7839 01-MAY-81       2850                    30
      7782 CLARK      MANAGER         7839 09-JUN-81       2450                    10
      7788 SCOTT      ANALYST         7566 09-DEC-82       3000                    20
      7839 KING       PRESIDENT            17-NOV-81       5000                    10
      7844 TURNER     SALESMAN        7698 08-SEP-81       1500          0         30
      7876 ADAMS      CLERK           7788 12-JAN-83       1100                    20
      7900 JAMES      CLERK           7698 03-DEC-81        950                    30
      7902 FORD       ANALYST         7566 03-DEC-81       3000                    20
      7934 MILLER     CLERK           7782 23-JAN-82       1300                    10

14 rows selected.

SQL> set underline off
SQL> select * from emp;

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
      7369 SMITH      CLERK           7902 17-DEC-80        800                    20
      7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30
      7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30
      7566 JONES      MANAGER         7839 02-APR-81       2975                    20
      7654 MARTIN     SALESMAN        7698 28-SEP-81       1250       1400         30
      7698 BLAKE      MANAGER         7839 01-MAY-81       2850                    30
      7782 CLARK      MANAGER         7839 09-JUN-81       2450                    10
      7788 SCOTT      ANALYST         7566 09-DEC-82       3000                    20
      7839 KING       PRESIDENT            17-NOV-81       5000                    10
      7844 TURNER     SALESMAN        7698 08-SEP-81       1500          0         30
      7876 ADAMS      CLERK           7788 12-JAN-83       1100                    20
      7900 JAMES      CLERK           7698 03-DEC-81        950                    30
      7902 FORD       ANALYST         7566 03-DEC-81       3000                    20
      7934 MILLER     CLERK           7782 23-JAN-82       1300                    10

14 rows selected.


See SQL*Plus Reference guide and especially the page containing the settings

[Updated on: Thu, 05 February 2009 00:06]

Report message to a moderator

Re: SQL plus report in excel format [message #384893 is a reply to message #384720] Thu, 05 February 2009 12:03 Go to previous message
konark
Messages: 24
Registered: February 2008
Location: Takhsila
Junior Member
Well said Frank . Blackswan never helped in solution , rather discouraged.
Previous Topic: function problem (merged 8)
Next Topic: Retrieve Ton N rows using aggregate functions.(merged 3)
Goto Forum:
  


Current Time: Sat Dec 03 08:13:13 CST 2016

Total time taken to generate the page: 0.09970 seconds