In SQL plus, when you use SPOOL option to spool out the output to a file, is it possible for us to have the date concatnate with the file name.
We don't want to hard code the file name and date. what I am trying to do is if I spool this file today it will stamp today date on my file name and let's say tomorrow I run it again it will stamp the date of tomorrow on the file instead of overwriting today's file.
You have set your escape character to "/". So when you do
CONNECT SYSTEM/MANAGER@DATABASE_B, Oracle treats character '/' as an escape character, so it thinks you want to connect as a user with username SYSTEMMANAGER and asks for a password for that user.
So before isuing CONNECT command, you must disable escape character or set it to some other character, using either
SET ESCAPE OFF or SET ESCAPE # (where you can replace # with any suitable character).
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?