Login Script

[RobertK]

version 5.1.3

Too many databases confusing me now......

Does this version allow log-in script ?
(like glogin.sql for sql*plus)

If so, how to enable ?

Thanks

 

[Marco Kalter]

You can use the AfterConnect.sql script in the PL/SQL Developer directory to specify SQL statements and PL/SQL blocks that need to be executed when a new connection is made. This will run for all sessions. For example:

alter session set nls_date_format='dd-mm-yyyy';
begin
  dbms_session.set_role('app_role');
end;
/

The Command Window will also execute a login.sql script in the PL/SQL Developer installation directory or from the SQLPATH, just like SQL*Plus.