i can create spool file for each login to SQL this way:
column whichdate new_value whichday noprint
select trunc(sysdate) whichdate from dual;
spool c:\...\File_&&whichday..txt
but once i terminate the session and again connect to SQL the new spool file is created which overwrites the data of previous spool file.
is there any way to save previous data, may using append clause.

can i create a spool file ,in same way, at server end for each client login to SQL.
with following details in it :
computer name or IP of that client,
session time, &
user name.

thanxcan i create a spool file ,in same way, at server end for each client login to SQL.
with following details in it :
computer name or IP of that client,
session time, &
user name.

thanx