Mercurial > sqlpython

comparison docs/source/capabilities.rst @ 342:80a1976decf2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
no changes i hope
author Catherine Devlin <catherine.devlin@gmail.com>
date Tue, 14 Apr 2009 16:11:59 -0400
parents 3efffbf7481f
children
comparison
equal deleted inserted replaced
338:a8835fe129f6 342:80a1976decf2
221 \\dt _dir_tables 221 \\dt _dir_tables
222 \\dv _dir_views 222 \\dv _dir_views
223 \\di _dir_indexes 223 \\di _dir_indexes
224 \\? help psql 224 \\? help psql
225 ===== =================== 225 ===== ===================
226
227 Multiple sessions
228 =================
229
230 When the `-a` flag is used with the `connect` or `\c` command, the new connection
231 is in addition to the old connection. `connect -a {username@instance}` is used to create a new connection, senora does not close the
232 old connection. It keeps both connections alive, and switching between them is far more convenient
233 than creating new connections::
234
235 0:jrrt@orcl> connect -a scott/tiger@orcl
236 1:scott@orcl> select * from dept;
237
238 DEPTNO DNAME LOC
239 ------ ---------- --------
240 10 ACCOUNTING NEW YORK
241 20 RESEARCH DALLAS
242 30 SALES CHICAGO
243 40 OPERATIONS BOSTON
244
245 4 rows selected.
246
247 1:scott@orcl> 0:select * from party;
248
249 NAME STR INT WIS DEX CON CHA
250 ------- --- --- --- --- --- ---
251 Frodo 8 14 16 15 14 16
252 Gimli 17 12 10 11 17 11
253 Legolas 13 15 14 18 15 17
254 Sam 11 9 14 11 16 13
255
256 4 rows selected.
257
258 1:scott@orcl> 0:
259 0:jrrt@orcl>
226 260
227 Bind variables 261 Bind variables
228 ============== 262 ==============
229 263
230 Bind variables work in sqlpython as they do in SQL\*Plus, but they are set dynamically; there 264 Bind variables work in sqlpython as they do in SQL\*Plus, but they are set dynamically; there