Skip to Main Content

Oracle Developer Tools for VS Code

Is it possible to run a login.sql script associated with a connection?

psychofarmSep 28 2019 — edited Mar 23 2020

When I use Oracle SQL Developer Version: 18.4.0.376.1900, I have a script called login.sql. The file contains session preferences.

For example:

ALTER SESSION SET current_schema = the_schema_used_most;

ALTER SESSION SET nls_date_format='yyyy-mm-dd';

The script runs whenever I connect.

How can I replicate this set up using Oracle Developer Tools for VS Code?

Thanks

Comments
Post Details
Added on Sep 28 2019
1 comment
267 views