Running/executing statements in the SQL Editor window does not apply to the current session, even though it was executed successfully.
For example;
If you run an alter statement such as
Alter session set NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
After the statement is ran, the NLS_DATE_FORMAT for the current session has not changed.
RESOLUTION #1:
Uncheck the following option under View | Options | Transactions | "Execute Queries in threads (Creates a separate session)"
RESOLUTION #2:
1. Create a .sql file that contains the Statement to be executed
For example
Alter session set NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
2. Save this file in your local directory. i.e. C:\date.sql
3. Select View | Options | Start up | "File to AutoExecute on new connections"
4. Place the location of the created file in this appropriate location.
5. Re-start Toad.
Note: If the above #2 is performed, each time Toad creates a new connection, the alter statement or any statement in the file will be executed after the connection has been established.
