PL/SQL Developer Primary Database connection and window connection switching

Oracle developer estimates are very familiar with PL/SQL developer, and there are some small function points that some beginners have not found. PL/SQL Developer supports multi-connection multiple windows, as detailed below.

1. Concept of the primary connection

   Open PL/SQL developer the login interface, the database connection after successful login is the primary connection. Both the new window and the open file use this primary connection, and the Object Browser also displays the contents of the primary connection. Characteristics of the primary connection

   1) Session menu Log on ..., inside that black body is the current primary connection.

   2) Connection List

   You can create new and open scripts directly at each connection point right-click.

   So what does this main connection mean?

   Official documents:

   The main connection is used for all functions in PL/SQL Developer where do not explicitly select a

   Connection. For example, when opening a new SQL Window and executing a query, you'll implicitly

   Create a database session for the main connection. The Object Browser'll also use the main

   Connection.

   After logging on PL/SQL Developer you have implicitly set the main connection. The main

   Connection can changed by using the Session > Log on function again, or by double-clicking on a

   Connection in the connection List. In the Connection List the main Connection are displayed in bold.

   "When you do not explicitly select a connection, PL/SQL Developer all features will use the primary connection. For example, if you open a new SQL window and run the query, you will implicitly establish a session with the primary connection. The Object Browser will also use this primary connection. On a successful login

   To change the primary connection:

   1. Session Menu Log on ...

   2, Connection list Double-click the connection. 】

   ?

   Second, the window pinning the connection function

   Each edit window can be a different connection, select from here, and after selecting this window will be automatically pinned to the connection.

   Next to the "pinned" sign is red, the connection to this window is unchanged in the case of a change in the primary connection, unaffected. If it is gray, then the connection to this window follows the main connection change.

PL/SQL Developer Primary Database connection and window connection switching