How to SPOOL &_something like in SQL*Plus

Hello RP0428,

I had already looked at this kind of info, no need to send me a RTFM in the face. Maybe I should have added in my question a more clear statement "I can do this in  SQL*Plus <...>; how can I do an equivalent in SQL Developer?" Then  sending the list of what is supported and what is not would have been irrelevant.

But I realize that I had over-simplified my question... We can do a direct & substitution, but what I want to do is to have this done via my "login.sql" file.

If we do directly

col x new_value _x

select 'c:\temp\aaa.log' x from dual;

spool &_x

select * from dual;

spool

spool off

this works as expected (file C:\temp\aaa.log created, and containing

> select * from dual

DUMMY

-----

X  

c:\temp\aaa.log

But in fact what I would like is to achieve the "spool ..." done via a kind of "login.sql". For example: when I run the script

connect scott/tiger@orcl1

@login.sql

select user from dual;

spool

with "login.sql" containing:

SET TIMI ON ECHO ON TERM ON

COLUMN logname NOPRINT NEW_VALUE _logname

SELECT 'c:\temp\' || user || TO_CHAR( sysdate, 'YYYY_MM_DD_HH24MISS' ) || '.log' logname FROM dual;

SET ECHO OFF HEA OFF TIMI OFF

SPOOL &_logname

SELECT 'script run with account ' || USER || ' on ' || TO_CHAR( sysdate, 'Dy DD-MON-YY' ) ||

       ' at ' || TO_CHAR( sysdate, 'HH24:MI:SS' )

  FROM dual;

SET ECHO ON HEA ON TIMI ON

the session prompts me for "_LOGNAME?", and for example the output is:

> connect scott/tiger@orcl1

Connected

> @login

> set TIMI ON

> set TERM ON

> COLUMN logname NOPRINT NEW_VALUE _logname

> SELECT 'c:\temp\' || user || TO_CHAR( sysdate, 'YYYY_MM_DD_HH24MISS' ) || '.log' logname FROM dual

Elapsed: 00:00:00.015

old:SPOOL &_logname

new:SPOOL c:\temp\poor.txt

script run with account SCOTT on Wed 01-OCT-14 at 19:41:01                                         

> set HEA ON

> set TIMI ON

> select user from dual

USER                        

------------------------------

SCOTT                    

Elapsed: 00:00:00.000

> spool

c:\temp\poor.txt

Connection created by CONNECT script command disconnected

(of course c:\temp\poor.txt is the value that I have given when prompted for _logname)

About the version, yes, 4 is OK, I didn't put it in my question as I thought that this wouldn't change the solution (but of course anybody might tell me "in SQLDeveloepr >= 3.2 you can do like this", or "you need the version 4 to do ..."). ((in version 4 I can define the file "bruno.sql" as "to be run after each connection" but this is a detail))

Best regards,

Bruno