|
|
|
Re: How to trim trailing spaces in DBMS_OUTPUT [message #281113 is a reply to message #281108] |
Thu, 15 November 2007 14:41   |
 |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
<comdb04-oracle@stagedb02.example.com:/a/oracle/tmp:> sqlplus -s dbadmin/admindb @tester.sql
2007-11-15 12:40:34
PL/SQL procedure successfully completed.
<comdb04-oracle@stagedb02.example.com:/a/oracle/tmp:> od -c tester.log
0000000 2 0 0 7 - 1 1 - 1 5 1 2 : 4 0
0000020 : 3 4 \n \n P L / S Q L p r o c
0000040 e d u r e s u c c e s s f u l
0000060 l y c o m p l e t e d . \n \n
0000077
<comdb04-oracle@stagedb02.example.com:/a/oracle/tmp:> cat tester.sql
spool tester.log
set serveroutput on trimspool on
declare
begin
dbms_output.enable(1000);
dbms_output.put_line(sysdate);
end;
/
exit
[Updated on: Thu, 15 November 2007 16:46] by Moderator Report message to a moderator
|
|
|
|
|
|