| exp then convert into a spreadshet [message #72112] |
Tue, 11 March 2003 12:05  |
Maria
Messages: 57
Registered: August 1999
|
Member |
|
|
Hi all
I need to do a export then convert into a spreadsheet, is this possible and how do you do that,, I can't figure this one out, can any one please please help
Thanks
Maria
|
|
|
|
| Re: exp then convert into a spreadshet [message #72113 is a reply to message #72112] |
Tue, 11 March 2003 12:58  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
the output of exp tool is oracle proprietory(binary)
YOU cannot open and view it.
if you are just looking to create a csv file or tab seperated file to load into excel, just spool the output.
C:>sqlplus -s mag/mag
set head off
set feed off
set term off
spool s.xls
select ename||chr(9)||sal from emp;
SMITH 800
ALLEN 1600
WARD 1250
JONES 2975
MARTIN 1250
BLAKE 2850
CLARK 2450
KING 5000
TURNER 1500
JAMES 950
FORD 3000
MILLER 1300
spool off
exit
C:>cat s.xls
SMITH 800
ALLEN 1600
WARD 1250
JONES 2975
MARTIN 1250
BLAKE 2850
CLARK 2450
KING 5000
TURNER 1500
JAMES 950
FORD 3000
MILLER 1300
C:>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
