Re: Unique spool filenames?

>>
>
>Brett,
>
>Thank you much for your help!
>
>There is one little problem with it that I don't know how
>to handle:
>
>SQL> column unique_id new_value uid noprint
>SQL> select userenv('SESSIONID') unique_id from dual;
>SQL> spool filename.&UID
>Illegal spool file name: "filename. 46080" (bad character: ' ')
>
>
>I've tried all sorts of format commands on the 'column' statement
>with no luck. Any ideas?
>
>If nothing else I will use 'spool &UID.filename'

Try this:
 SQL> select to_char(userenv('SESSIONID')) unique_id from dual;

This will help.

Sheilah Scheurich
DBA Received on Wed May 07 1997 - 00:00:00 CDT