http://tkyte.blogspot.fr/2010/04/new-thing-about-sqlplus.html
- Start with
123
set
errorlogging
on
identifier toto
delete
from
sperrorlog
where
identifier =
'toto'
/
- Then use some sqlplus commands
- And terminate with
1234
col nb_errors new_value nb_errors
select
count
(*)
as
nb_errors
from
sperrorlog
where
identifier =
'toto'
/
exit nb_errors
NB: See http://ss64.com/ora/syntax-sqlplus.html for the sqlplus syntax