sqlplus and feedback
- From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Jan 2014 11:55:10 +0100
Hi!
I wonder if is there a way to have an apple and eat it, i.e.
get the display of rows (which is done by feedback on) and yet suppress
this very line in the spooled log (which is intended to be a generated
script).
Of course I may do it with earlier select count(*) (which however means
the db work x2) or count the log lines (as I spool here) with some
shell command (which is acceptable, but not necessarily a very beautiful
solution)
Best regards
Remigiusz
--
Pole na kazi
----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
pos : Senior DBA at DIiUSI
addr : Nordea IT Polska Sp. z o.o., Luzycka 6A st, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
54.4952N 18.4332E
Nordea IT Polska Sp.z o.o. z siedziba w 00-854 Warszawa, Al.Jana Pawla II 25,
lok.IXp.
wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem: 0000429783,
dla której dokumentacje przechowuje Sad Rejonowy dla M.St. Warszawy w Warszawie,
XII Wydzial Gospodarczy Krajowego Rejestru Sadowego,
o kapitale zakladowym i oplaconym w wysokosci: 40.000.000,00 zlotych,
NIP: 527-268-29-50, REGON: 146278110
Adres do korespondencji: 81-537 Gdynia, ul. Luzycka 6A
--
//www.freelists.org/webpage/oracle-l
Other related posts:
