format output file by command spool [message #490084] |
Thu, 20 January 2011 21:55 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
chuikingman
Messages: 90 Registered: August 2009
|
Member |
|
|
Hi,
I use sqplus in oracle to output the command output to text file .
I use below set environment varialble.
SQL> set echo off;
SQL> set linesize 3999;
SQL> set feedback off;
SQL> set feedback off;
SQL> set termout off;
SQL> set pagesize 0;
SQL> spool mapping.txt
select C_SIM_MSISDN,C_SIM_IMSI from RCA_SMART_CARD order by C_SIM_MSISDN;
In ouput file , it look like
SQL> select C_SIM_MSISDN,C_SIM_IMSI from RCA_SMART_CARD order by C_SIM_MSISDN;
060010007 10007
:
:
:
SQL> spool off;
any setting or command that allow me to remove
the first sql command line" SQL>select XXXX"
and the last command "SQL>spool off" after start up the "spool mapping.txt"
|
|
|
|
Re: format output file by command spool [message #490093 is a reply to message #490088] |
Thu, 20 January 2011 23:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
chuikingman
Messages: 90 Registered: August 2009
|
Member |
|
|
I only want the output file mapping.txt .
The fjrst line " SQL>select XXX " and the last line " SQL>spool off"
is removed in ths output file mapping.txt .
I do not want to use editor to edit the file as the file is hugh in size .
Any command and setting can do this in sql ???
|
|
|
Re: format output file by command spool [message #490097 is a reply to message #490093] |
Thu, 20 January 2011 23:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/3407c5321d044ad76d2ebbfcebcc9950?s=64&d=mm&r=g) |
aha613
Messages: 6 Registered: January 2011 Location: Sydney
|
Junior Member |
|
|
Hi there,
Try this way.
1.save your staff in c:\script.sql.
2. run sqlplus
3. File->open->c:\script.sql
it will show the source code of your script
4. at prompt, type in @script<enter>
c: user/db >@script<enter>
5. check your txt file. it should be exactly what you want.
Fingers cross.
Phil
[Updated on: Thu, 20 January 2011 23:34] Report message to a moderator
|
|
|
|
Re: format output file by command spool [message #490101 is a reply to message #490097] |
Fri, 21 January 2011 00:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
chuikingman
Messages: 90 Registered: August 2009
|
Member |
|
|
aha613 wrote on Fri, 21 January 2011 13:33Hi there,
Try this way.
1.save your staff in c:\script.sql.
2. run sqlplus
3. File->open->c:\script.sql
it will show the source code of your script
4. at prompt, type in @script<enter>
c: user/db >@script<enter>
5. check your txt file. it should be exactly what you want.
Fingers cross.
Phil
I use linux /Unix environment only , no window .
Please advice other way ...
|
|
|
|
|
Re: format output file by command spool [message #503697 is a reply to message #503680] |
Tue, 19 April 2011 01:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:connect sys/manager as sysdba
This is VERY VERY bad.
- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the immediate answer)
- SYS/SYSDBA does not act like any other user
- When you use SYS/SYSDBA Oracle deactivates some code path and activates others
- Whatever you do with SYS/SYSDBA will neither validate nor invalidate the same thing with any other user.
NEVER EVER use SYS/SYSDBA for anything that can be done by another user.
Use SYS/SYSDBA ONLY for something that can't be done by someone else.
Regards
Michel
|
|
|