Re: easy sql question

IKerr. wrote:

<snipped>
> "SP2-0734: unknown command beginning "Enter valu..." - rest of line
> ignored."
>
> How can I make the lines disappear from the spooled script before it is
> run.

SET define off

This will disable all SQL*Plus prompts caused by the & char, e.g.

SQL> Prompt &Hello there
Enter value for &Hello:

vs.

SQL> set define off;
SQL> Prompt &Hello there
&Hello there

--
Billy