SQL - on break
From: IainS <iains_at_aol.com>
Date: 6 Dec 1994 10:15:14 -0500
Message-ID: <3c1v62$3ff_at_newsbf01.news.aol.com>
Date: 6 Dec 1994 10:15:14 -0500
Message-ID: <3c1v62$3ff_at_newsbf01.news.aol.com>
Hi
I am writing a SQL*Plus script as follow :
on break b1 nodup skip 4
spool grant.sql
select 'connect '||owner||'/'||owner b1, '
', grant all on '||table_name||' to casemgr;'
from sys.dba_tables
/
spool off
exit
Why is the on break not working.
Please also reply to IainS_at_aol.com
Thanks
Iain
Received on Tue Dec 06 1994 - 16:15:14 CET