Re: SQL*Plus question

Mike,

Don't include the logon on the command line. Use 'sqlplus _at_script' from Unix and in the sql script put:
logon/password
(blank)
(blank)

SELECT * FROM emp;
...

The two blank lines do nothing if the logon is successful and cause the 2nd and third unsuccessful logons required to blow you out of SQL*Plus. You could pass the logon and password into the script as &1 and &2 parameters if you need them on the command line.

Robert. Received on Tue May 14 1996 - 00:00:00 CEST