Forum Stats

  • 3,874,176 Users
  • 2,266,677 Discussions
  • 7,911,757 Comments

Discussions

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

psychofarm
psychofarm Member Posts: 2 Green Ribbon

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

Answers