execute an init sql script when establishing a connection

The purpose is to be able to init some sql parameters when establishing  a connection to the database.

DbVisualizer to allow this, let you enter some sql commands that will be executed when the connection is made. They call this a "connection hook". I think this is a simple and powerful way to allow this type of configuration.

This is an exemple of use :

ALTER SESSION SET CURRENT_SCHEMA = TOTO;
ALTER SESSION SET TIME_ZONE='Australia/Sydney';

 

0

请先登录再写评论。