Re: SQL - on break

In article <James.Lawrence.61.000C71D9_at_epamail.epa.gov>, James.Lawrence_at_epamail.epa.gov (Lawrence James) says:
>
>In article <3c1v62$3ff_at_newsbf01.news.aol.com> iains_at_aol.com (IainS) writes:
>>From: iains_at_aol.com (IainS)
>>Subject: SQL - on break
>>Date: 6 Dec 1994 10:15:14 -0500
 

>>Hi
 

>>I am writing a SQL*Plus script as follow :
 

>>on break b1 nodup skip 4
>
>It's 'Break on.....'
>
>>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
>

Also, the alias which you are refeering to, b1, is inside the quoatations. It should be outside the quotations or the break statement will not recognize the column, so:

 select 'connect '||owner||'/'||owner, ' b1 <- this will now be recognized ', grant all on '||table_name||' to casemgr;' from sys.dba_tables Received on Mon Dec 12 1994 - 14:07:30 CET