SQL plus report in excel format [message #384678] |
Wed, 04 February 2009 15:29  |
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 #384720 is a reply to message #384681] |
Wed, 04 February 2009 23:57   |
Frank
Messages: 7901 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   |
Frank
Messages: 7901 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
|
|
|
|