Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: spool file name question
thanks for the tip Sybrand!
cindy
Sybrand Bakker wrote:
> Contrary to the other post,
>
> the best method to do this
> is to include
> define fnam = '&1'
> spool &fnam
>
> This will also make your code more readable.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> <kal121_at_my-deja.com> wrote in message news:8qu2c1$t14$1_at_nnrp1.deja.com...
> > I'm trying to create a name for a spool file on the fly. &1 is a
> > parameter I pass to this script. In the script, I build up the spool
> > file name as follows:
> >
> > spool $SCRIPTS/ddl/'&1'_utl_recreate.sql
> >
> > This works ok, the file name ends up looking like this:
> >
> > 'dev1'_utl_create.sql
> >
> > If I don't put the single quotes around &1, it assumes it is
> > interactive waits for user input. This I don't want. Is there a better
> > way of doing this?
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Thu Sep 28 2000 - 03:23:05 CDT