0 Replies Latest reply on Sep 28, 2019 11:26 AM by psychofarm

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

    psychofarm

      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