This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
multiple-databases [2016/01/22 15:34] dmtolpeko [Why Multiple Databases?] |
multiple-databases [2016/01/22 15:35] dmtolpeko [Default Connection] |
||
---|---|---|---|
Line 20: | Line 20: | ||
Before you can work with multiple databases, you have to [[connections|configure connections]]. | Before you can work with multiple databases, you have to [[connections|configure connections]]. | ||
- | PL/HQL connects to a database only when it executes the first SQL statement for this database, the tool does not connect to any database in advance. | + | HPL/SQL connects to a database only when it executes the first SQL statement for this database, the tool does not connect to any database in advance. |
- | Once connected, PL/HQL holds and re-uses the connection until the script completes. | + | Once connected, HPL/SQL holds and re-uses the connection until the script completes. |
===== Default Connection ===== | ===== Default Connection ===== | ||
- | By default, PL/HQL uses the connection profile defined by the [[configuration#plhqlconndefault|plhql.conn.default]] option. | + | By default, HPL/SQL uses the connection profile defined by the [[configuration#hplsqlconndefault|hplsql.conn.default]] option. |
===== Map Database Objects to Use Other Connections ===== | ===== Map Database Objects to Use Other Connections ===== |