Re: SQL - on break

From: Leslie A. Kopari Jr. <lkopari_at_garlic.com>
Date: 8 Dec 1994 22:39:12 -0800
Message-ID: <3c8u2g$qi7_at_garlic.com>


IainS (iains_at_aol.com) wrote:
: 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

Isn't the statement known as 'break on'?

I'm afraid I suffer from the too-many-languages syndrome. Received on Fri Dec 09 1994 - 07:39:12 CET

Original text of this message