Mercurial > sqlpython
annotate docs/source/capabilities.rst @ 514:ea547649a1b8
fix case in oracle queries
| author | catherine.devlin@gmail.com |
|---|---|
| date | Tue, 02 Nov 2010 04:14:00 -0400 |
| parents | 46589473c36b |
| children | 539c11ad1b7e |
| rev | line source |
|---|---|
| 281 | 1 ============================== |
| 247 | 2 SQLPython's extra capabilities |
| 3 ============================== | |
| 4 | |
| 444 | 5 SQLPython's primary function is to allow entry of SQL queries, much like |
| 6 SQL*Plus, psql, and the mysql command-line client. It aims to reproduce | |
| 7 as many SQL*Plus capabilities as possible. In addition, it offers several | |
| 8 extra features inspired by other command-line clients. | |
| 247 | 9 |
| 279 | 10 Neatened output |
| 11 =============== | |
| 12 | |
| 13 When printing query results, sqlpython economizes on screen space by allocating | |
| 14 only the width each column actually needs. | |
| 15 | |
| 16 Smart prompt | |
| 17 ============ | |
| 18 | |
| 19 sqlpython automatically uses `username`@`instance`> as its prompt, helping | |
| 20 avoid wrong-instance and wrong-user errors. | |
| 21 | |
| 22 Tab completion | |
| 23 ============== | |
| 24 | |
| 25 When typing SQL commands, hitting `<TAB>` after entering part of an object | |
| 26 or column name brings up a list of appropriate possibilities or, if there | |
| 27 is only one possibility, fills in the rest of the name. This feature is | |
| 28 not yet very reliable, but can save typing. | |
| 29 | |
| 30 Scripting | |
| 31 ========= | |
| 32 | |
| 33 Like SQL\*Plus, sqlpython can run scripts (text files with series of SQL and | |
| 34 sqlpython commands) with `@/path/to/script.sql` or (for online scripts) | |
| 35 `@http://scripthost/scriptlibrary/script.sql`. | |
| 36 | |
| 37 History | |
| 38 ======= | |
| 39 | |
| 456 | 40 If used on a \*nix machine with ``readline`` installed, then ``bash``-like access |
|
445
b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
catherine@Drou
parents:
444
diff
changeset
|
41 to the command history is available. |
|
b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
catherine@Drou
parents:
444
diff
changeset
|
42 |
| 279 | 43 The up- and down-arrow keys allow you to scroll through the lines entered so far |
| 44 in your sqlpython session. | |
| 45 | |
| 46 Commands are also entered into a command history. | |
| 47 | |
| 286 | 48 history *or* hi |
| 49 List entire command history | |
| 279 | 50 |
| 286 | 51 list *or* li |
| 52 List only last command | |
| 279 | 53 |
| 286 | 54 hi `<N>` |
| 55 List command number <N> from history. | |
| 279 | 56 |
| 286 | 57 hi `<N>-`, hi `-<N>` |
| 58 List commands from <N> onward, or up to <N> | |
| 279 | 59 |
| 286 | 60 hi `<str>` |
| 61 Lists commands that include the string <str> | |
| 279 | 62 |
| 286 | 63 hi `/<regex>/` |
| 64 Lists commands that match the regular expression <regex> | |
| 279 | 65 |
| 286 | 66 run, r, *or* `\\g` |
| 67 Run the most recent command again | |
| 279 | 68 |
| 286 | 69 run `<N>` |
| 70 Run command <N> | |
| 279 | 71 |
| 286 | 72 run `<str>`, run `/<regex>/` |
| 73 Run command matching <str> or <regex> (as for `history`) - | |
| 74 if multiple items would match, run most recent | |
| 279 | 75 |
| 281 | 76 Special I/O destinations |
| 77 ======================== | |
| 78 | |
| 79 Much as in a UNIX shell, you can follow a command with a special output destination. | |
| 80 | |
| 81 `> {filename}` sends the output to a file. This is more convenient than SQL\*Plus's | |
| 82 SPOOL {filename}... SPOOL OFF (though you can use those as well). | |
| 83 | |
| 84 `>` alone (no filename) sends the output to the paste buffer. | |
| 85 | |
| 86 `|` pipes the output to an operating-system command. | |
| 87 | |
| 88 When `< {filename}` is included in your command, it is replaced with the contents of | |
| 89 {filename} before the command is run. | |
| 90 | |
| 91 Examples:: | |
| 92 | |
| 283 | 93 Need examples!!!! |
| 94 | |
| 281 | 95 Special output formats |
| 96 ====================== | |
| 97 | |
| 98 By replacing the `;` that terminates a SELECT statement with a backslash-character | |
| 99 sequence, you can get output in a number of useful formats. The `terminators` | |
| 283 | 100 command lists them, for your convenience. |
| 281 | 101 |
| 283 | 102 ========== ======================== ================================ |
| 103 terminator format Useful for | |
| 104 ========== ======================== ================================ | |
| 105 ; standard Oracle format | |
| 106 \\c CSV (with headings) sending to spreadsheets | |
| 107 \\C CSV (no headings) | |
| 108 \\g list wide output with linewraps | |
| 109 \\G aligned list | |
| 110 \\h HTML table web reports | |
| 111 \\i INSERT statements copying to other instances | |
| 112 \\j JSON | |
|
329
3efffbf7481f
fixed bug in assigning 0, null to bind vars
Catherine Devlin <catherine.devlin@gmail.com>
parents:
294
diff
changeset
|
113 \\r ReStructured Text inclusion in documentation |
| 283 | 114 \\s CSV (with headings) |
| 115 \\S CSV (no headings) | |
|
329
3efffbf7481f
fixed bug in assigning 0, null to bind vars
Catherine Devlin <catherine.devlin@gmail.com>
parents:
294
diff
changeset
|
116 \\t transposed "wide" tables like v$database |
| 283 | 117 \\x XML |
| 118 \\l line plot, with markers | |
| 119 \\L scatter plot (no lines) | |
| 120 \\b bar graph | |
| 121 \\p pie chart | |
| 122 ========== ======================== ================================ | |
| 281 | 123 |
| 124 Most of these output formats are even more useful when combined with special output | |
|
329
3efffbf7481f
fixed bug in assigning 0, null to bind vars
Catherine Devlin <catherine.devlin@gmail.com>
parents:
294
diff
changeset
|
125 destinations. For example, `SELECT * FROM party\\h > /var/www/party_report.html` |
| 281 | 126 could create an HTML report in the webserver's documents directory, ready to serve. |
| 127 | |
| 247 | 128 UNIX-like commands |
| 129 ================== | |
| 130 | |
| 279 | 131 Many sqlpython commands allow you to act as though the database objects |
| 132 were files in a UNIX filesystem. Many of the commands also accept flags | |
| 133 to modify their behavior. | |
| 134 | |
| 286 | 135 ls `{object type/object name, with wildcards}` |
| 281 | 136 Lists objects from the data dictionaries, as though they were in a |
| 137 *object_type*/*object_name* directory structure. Thus, `ls view/\*` | |
| 138 lists all the user's views. Calling with no argument is equivalent | |
| 139 to `ls *`. | |
| 140 | |
| 141 Options:: | |
| 142 | |
| 143 -l, --long long descriptions | |
| 144 -a, --all all schemas' objects (otherwise, you only get your own) | |
| 145 -t, --timesort Sort by last_ddl_time | |
| 146 -r, --reverse Reverse order while sorting | |
| 247 | 147 |
| 281 | 148 `ls -lt *;10` lists the ten items with the most recent last_ddl_time; |
| 149 this can be a good way to answer the question, "What was I working on?" | |
| 150 | |
| 286 | 151 cat `{remainder of query}` |
| 152 Shorthand for "SELECT * FROM". Can be combined with anything else | |
| 153 that fits into a SELECT statement (WHERE, ORDER BY, etc.) | |
| 281 | 154 |
| 286 | 155 grep `{target}` `{table}` `[{table2,...}]` |
| 156 Equivalent to SELECT * FROM {table} WHERE *any column* LIKE '%{target}%'. | |
| 157 Useful when you don't know, don't remember, or don't care which column | |
| 158 a value may be found in. | |
| 281 | 159 |
| 160 Options:: | |
| 161 | |
| 162 -i, --ignore-case Case-insensitive search | |
| 247 | 163 |
| 281 | 164 find -c {target}, find -t {column} |
| 165 Lists all tables or columns whose names contain {target}. More convenient than | |
| 166 querying user_tab_columns/all_tab_columns or user_tables/all_tables. | |
| 167 Options:: | |
| 283 | 168 |
| 281 | 169 -a Find all objects (not just my own) |
| 170 | |
| 286 | 171 Data dictionary exploration |
| 172 =========================== | |
| 173 | |
| 174 refs `{table_name}` | |
| 175 Lists all foreign key constraints on the table or referring to the table. | |
| 176 | |
| 177 deps `{object_name}` | |
| 178 Lists all objects dependent upon the named object. | |
| 179 | |
| 180 comments `{table_name}` | |
| 181 Prints comments on a table and its columns. | |
| 182 | |
| 183 PL/SQL source code | |
| 184 ================== | |
| 185 | |
| 186 pull {object_name} | |
| 187 Displays the PL/SQL source code for {object_name}. | |
| 188 | |
| 189 Options: | |
| 190 -d, --dump dump results to files (object_type/object_name.sql) | |
| 191 -f, --full get dependent objects as well | |
| 192 -a, --all all schemas' objects | |
| 193 | |
| 194 bzr, git, hg `{object_name}` | |
| 195 Dump source code to files, as `pull -f`, but also creates or commits to a | |
| 196 repository of the appropriate distributed version control system | |
| 197 (Bazaar, Git, or Mercurial, respectively). | |
| 198 | |
| 199 find `{target}` | |
| 200 Lists all PL/SQL objects whose source code contains the {target} string. | |
| 201 Always case-insensitive. | |
| 202 Options:: | |
| 203 | |
| 204 -a Search all PL/SQL objects (not just my own) | |
| 205 | |
| 247 | 206 PostgreSQL-like shortcuts |
| 207 ========================= | |
| 208 | |
| 283 | 209 psql, the command-line client for the open-source database `PostgreSQL <http://www.postgresql.org/>`_ uses a number |
| 210 of backslash-character sequences as convenient shortcuts. sqlpython steals many of | |
| 211 them. | |
| 212 | |
| 213 ===== =================== | |
| 247 | 214 \\c connect |
| 215 \\d desc | |
| 216 \\e edit | |
| 217 \\g run | |
| 218 \\h help | |
| 219 \\i load | |
| 220 \\o spool | |
| 221 \\p list | |
| 222 \\q quit | |
| 223 \\w save | |
| 224 \\db _dir_tablespaces | |
| 225 \\dd comments | |
| 226 \\dn _dir_schemas | |
| 227 \\dt _dir_tables | |
| 228 \\dv _dir_views | |
| 229 \\di _dir_indexes | |
| 230 \\? help psql | |
| 283 | 231 ===== =================== |
| 281 | 232 |
| 233 Bind variables | |
| 234 ============== | |
| 235 | |
| 236 Bind variables work in sqlpython as they do in SQL\*Plus, but they are set dynamically; there | |
| 237 is no need to declare them before use. The syntax for setting them is more permissive than | |
| 238 in SQL\*Plus; all these are recognized:: | |
| 239 | |
| 240 exec :mybind := 'value' | |
| 241 exec :mybind = 'value' | |
| 242 :mybind := 'value' | |
| 243 :mybind = 'value' | |
| 244 | |
| 245 The current values of all bind variables can be viewed with the `print` command. | |
| 246 | |
| 247 The `bind` command creates and populates bind variables for the final row of the most recent | |
| 248 SELECT statement executed; each column name is used as a bind variable, which is filled with | |
| 249 the value. `bind -r {rownumber}` does the same, but fills from row {rownumber} instead of | |
| 250 from the final row (row numbers begin at 0 for this command). | |
| 251 | |
| 252 When the `autobind` sqlpython parameter is True, a `bind` statement is issued automatically | |
| 253 after every query that returns exactly one row. | |
| 254 | |
|
445
b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
catherine@Drou
parents:
444
diff
changeset
|
255 Once bind variables are defined, they can be used in SQL statements. The syntax |
|
b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
catherine@Drou
parents:
444
diff
changeset
|
256 is dependnent on which RDBMS is being queried. |
|
b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
catherine@Drou
parents:
444
diff
changeset
|
257 |
|
b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
catherine@Drou
parents:
444
diff
changeset
|
258 ---------- ------------------------------------------ |
|
b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
catherine@Drou
parents:
444
diff
changeset
|
259 RDBMS bind variable example |
|
b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
catherine@Drou
parents:
444
diff
changeset
|
260 ---------- ------------------------------------------ |
|
b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
catherine@Drou
parents:
444
diff
changeset
|
261 Oracle SELECT * FROM party WHERE name = :name; |
|
b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
catherine@Drou
parents:
444
diff
changeset
|
262 postgreSQL SELECT * FROM party WHERE name = %(name)s; |
|
b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
catherine@Drou
parents:
444
diff
changeset
|
263 MySQL SELECT * FROM party WHERE name = ; |
|
b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
catherine@Drou
parents:
444
diff
changeset
|
264 ---------- ------------------------------------------ |
|
b34ea206c7d1
debug bind var dependence on arg.parsed.expanded
catherine@Drou
parents:
444
diff
changeset
|
265 |
| 281 | 266 Bind variables are available from within Python as a dictionary named `binds` (see Python). |
| 267 | |
| 268 Substitution variables | |
| 269 ====================== | |
| 270 | |
| 271 Substitution variables ("&" variables) work much as they do in SQL\*Plus. As in SQL\*Plus, | |
| 272 the `scan` parameter determines whether queries are scanned to replace substitution | |
| 273 variables. Unlike SQL\*Plus, sqlpython knows how annoying it is to hit a substitution | |
| 274 variable you didn't expect, so entering "SET SCAN OFF" when prompted for a substitution | |
| 275 variable actually aborts the substitution process. | |
| 276 | |
| 247 | 277 Wild SQL |
| 278 ======== | |
| 279 | |
| 280 Wild SQL is a nonstandard SQL feature that must be enabled with `set wildsql on`. When it is | |
| 282 | 281 enabled, column names in a SELECT statement do not need to be explicitly typed; they can be |
| 282 specified with special Wild SQL symbols: wildcards (`*`, `%`, `_`); column numbers (`#{N}`); | |
| 283 and NOT-style exclusion (`!`). The symbols can even be combined. | |
| 247 | 284 |
| 456 | 285 TODO: column number Wild SQL is not working as of sqlpython 1.7.0 |
| 286 | |
| 282 | 287 :: |
| 247 | 288 |
| 282 | 289 jrrt@orcl> cat party |
| 290 | |
| 291 NAME STR INT WIS DEX CON CHA | |
| 292 ------- --- --- --- --- --- --- | |
| 293 Frodo 8 14 16 15 14 16 | |
| 294 Gimli 17 12 10 11 17 11 | |
| 295 Legolas 13 15 14 18 15 17 | |
| 296 Sam 11 9 14 11 16 13 | |
| 297 | |
| 298 4 rows selected. | |
| 299 | |
| 300 jrrt@orcl> set wild on | |
| 301 wildsql - was: False | |
| 302 now: True | |
| 303 jrrt@orcl> select *i* from party; | |
| 304 | |
| 305 INT WIS | |
| 306 --- --- | |
| 307 14 16 | |
| 308 12 10 | |
| 309 15 14 | |
| 310 9 14 | |
| 311 | |
| 312 4 rows selected. | |
| 313 | |
| 314 jrrt@orcl> select #1, #5 from party; | |
| 315 | |
| 316 NAME DEX | |
| 317 ------- --- | |
| 318 Frodo 15 | |
| 319 Gimli 11 | |
| 320 Legolas 18 | |
| 321 Sam 11 | |
| 322 | |
| 323 4 rows selected. | |
| 324 | |
| 325 jrrt@orcl> select !str from party; | |
| 326 | |
| 327 NAME INT WIS DEX CON CHA | |
| 328 ------- --- --- --- --- --- | |
| 329 Frodo 14 16 15 14 16 | |
| 330 Gimli 12 10 11 17 11 | |
| 331 Legolas 15 14 18 15 17 | |
| 332 Sam 9 14 11 16 13 | |
| 333 | |
| 334 4 rows selected. | |
| 335 | |
| 336 jrrt@orcl> select n*, !#3, !c* from party; | |
| 337 | |
| 338 NAME STR WIS DEX | |
| 339 ------- --- --- --- | |
| 340 Frodo 8 16 15 | |
| 341 Gimli 17 10 11 | |
| 342 Legolas 13 14 18 | |
| 343 Sam 11 14 11 | |
| 344 | |
| 345 4 rows selected. | |
| 247 | 346 |
| 282 | 347 Wild SQL symbols only work in the first SELECT statement in a query; they do not work in |
| 348 subqueries, subsequent UNIONed queries, etc. | |
| 349 | |
| 350 Python | |
| 351 ====== | |
| 352 | |
| 353 The `py` command allows the user to execute Python commands, either one-at-a-time (with | |
| 354 `py {command}`) or in an interactive environment (beginning with a bare `py` statement, | |
| 294 | 355 and continuing until Ctrl-D, `quit()`, or `exit()` is entered). |
| 282 | 356 |
| 357 A history of result sets from each query is exposed to the python session as the list `r`; | |
| 294 | 358 the most recent result set is `r[-1]`. Each row can be references as a tuple, or as an |
| 359 object with an attribute for each column. | |
| 360 | |
| 361 Bind variables are exposed as the dictionary `binds`. Each row from each result set has | |
| 362 a .bind() method that fills a bind varible for each column with that row's value. | |
| 282 | 363 |
| 364 Resultsets in `r` are read-only, but `binds` can be written as well as read, and will | |
| 365 be working bind variables in the SQL environment. | |
| 366 | |
| 294 | 367 SQL and sqlpython commands can be issued from the Python environment with `sql("{your SQL}")`. |
| 368 | |
| 369 All variables are retained each time the python environment is entered (whether interactively, | |
| 370 or with one-line `py` statements). | |
| 282 | 371 :: |
| 247 | 372 |
| 294 | 373 0:testschema@orcl> select title, author from play; |
| 282 | 374 |
| 375 TITLE AUTHOR | |
| 376 --------------- ----------- | |
| 377 Timon of Athens Shakespeare | |
| 378 Twelfth Night Shakespeare | |
| 379 The Tempest Shakespeare | |
| 380 Agamemnon Aeschylus | |
| 381 | |
| 382 4 rows selected. | |
| 383 | |
| 294 | 384 0:testschema@orcl> py import urllib |
| 385 0:testschema@orcl> py current_season = urllib.urlopen('http://cincyshakes.com/').read() | |
| 386 0:testschema@orcl> py | |
| 387 Python 2.5.2 (r252:60911, Jul 31 2008, 17:28:52) | |
| 388 [GCC 4.2.3 (Ubuntu 4.2.3-2ubuntu7)] on linux2 | |
| 389 Type "help", "copyright", "credits" or "license" for more information. | |
| 390 (mysqlpy) | |
| 391 | |
| 392 py <command>: Executes a Python command. | |
| 393 py: Enters interactive Python mode; end with `Ctrl-D`, `quit()`, or 'exit`. | |
| 394 Past SELECT results are exposed as list `r`; | |
| 395 most recent resultset is `r[-1]`. | |
| 396 SQL bind, substitution variables are exposed as `binds`, `substs`. | |
| 397 SQL and sqlpython commands can be issued with sql("your non-python command here"). | |
| 398 | |
| 282 | 399 >>> r[-1] |
| 400 [('Timon of Athens', 'Shakespeare'), ('Twelfth Night', 'Shakespeare'), ('The Tempest', 'Shakespeare'), ('Agamemnon', 'Aeschylus')] | |
| 294 | 401 >>> r[-1][0][0] |
| 402 'Timon of Athens' | |
| 282 | 403 >>> for row in r[-1]: |
| 294 | 404 ... print "%s, by %s" % (row.title, row.author) |
| 405 ... | |
| 406 Timon of Athens, by Shakespeare | |
| 407 Twelfth Night, by Shakespeare | |
| 408 The Tempest, by Shakespeare | |
| 409 Agamemnon, by Aeschylus | |
| 282 | 410 >>> [row.title for row in r[-1] if row.title in current_season] |
| 411 ['Timon of Athens', 'Twelfth Night'] | |
| 294 | 412 >>> binds['author'] = 'Shakespeare' |
| 413 >>> query = "SELECT title FROM play WHERE author = :author" | |
| 414 >>> sql(query) | |
| 415 | |
| 416 TITLE | |
| 417 --------------- | |
| 418 Timon of Athens | |
| 419 Twelfth Night | |
| 420 The Tempest | |
| 421 | |
| 422 3 rows selected. | |
| 423 | |
| 424 >>> r[-1] | |
| 425 [('Timon of Athens',), ('Twelfth Night',), ('The Tempest',)] | |
| 426 >>> r[-1][0] | |
| 427 ('Timon of Athens',) | |
| 428 >>> r[-1][0].bind() | |
| 429 >>> binds['title'] | |
| 430 'Timon of Athens' | |
| 431 >>> quit() | |
| 432 0:testschema@orcl> select title, author from play where title = :title; | |
| 282 | 433 |
| 434 TITLE AUTHOR | |
| 435 --------------- ----------- | |
| 436 Timon of Athens Shakespeare | |
| 437 | |
| 438 1 row selected. | |
| 294 | 439 |
| 281 | 440 Parameters |
| 441 ========== | |
| 442 | |
| 443 Several parameters control the behavior of sqlpython itself. | |
| 444 | |
| 283 | 445 ===================== =================================================== =============== |
| 446 parameter effect default | |
| 447 ===================== =================================================== =============== | |
| 448 autobind When True, single-row queries automatically `bind` False | |
| 449 commit_on_exit Automatically commits work at end of session True | |
| 450 continuation_prompt Prompt for second line and onward of long statement > | |
| 451 default_file_name The file opened by `edit`, if not specified afiedt.buf | |
| 452 echo Echo command entered before executing False | |
| 453 editor Text editor invoked by `edit`. varies | |
| 294 | 454 heading Print column names along with results True |
| 283 | 455 maxfetch Maximum number of rows to return from any query 1000 |
| 456 maxtselctrows Maximum # of rows from a tselect or \\n query 10 | |
| 457 prompt Probably unwise to change user@instance> | |
| 458 scan Interpret & as indicating substitution variables True | |
| 459 serveroutput Print DBMS_OUTPUT.PUT_LINE results True | |
| 460 sql_echo Print text of "behind-the-scenes" queries False | |
| 461 timeout In seconds 30 | |
| 462 timing Print time for each command to execute False | |
| 456 | 463 wildsql Accept \*, %, #, and ! in column names False |
| 283 | 464 ===================== =================================================== =============== |
| 281 | 465 |
| 466 The user can change these with the `set {paramname} {new-value}` statement. | |
| 283 | 467 The True/False parameters accept new values permissively, recognizing "True", "False", |
| 468 "T", "F", "yes", "no", "on", "off", etc. | |
| 281 | 469 |
| 283 | 470 `set` and `show` both list the current values of the sqlpython parameters. They |
| 471 also recognize any abbreviated parameter name, so long as it is long enough to be | |
| 472 unique. That is, `show maxf` is recognized as `show maxfetch`, but `show max` is | |
| 473 too short to distinguish between `maxfetch` and `maxtselctrows`. | |
| 474 | |
| 281 | 475 `show parameter {param}` shows current Oracle parameters (from v$parameter), as it does |
| 476 in SQL\*Plus. | |
| 477 | |
| 478 Tuning | |
| 479 ====== | |
| 480 | |
| 481 In sqlpython, `explain {SQL ID}` shows the execution plan for the SQL statement with the | |
| 482 given ID. If SQL ID is omitted, it defaults to the most recent SQL executed. | |
| 483 (This is not necessarily the last statement `EXPLAIN PLAN` was issued against.) | |
| 484 | |
| 485 Other specialized sqlpython tuning commands include: | |
| 486 | |
| 487 load | |
| 488 Displays OS load on cluster nodes (10gRAC) | |
| 489 | |
| 490 longops | |
| 491 Displays long-running operations | |
| 492 | |
| 493 sessinfo | |
| 494 Reports session info for the given sid, extended to RAC with gv$ | |
| 495 | |
| 496 top, top9i | |
| 497 Displays active sessions | |
| 498 | |
| 373 | 499 BLOB display |
| 500 ============ | |
| 501 | |
| 502 (Oracle only, for now) | |
| 503 | |
| 504 When a SELECT query returns BLOB columns, most SQL tools simply cannot | |
| 505 display the results. Sqlpython, however, will create | |
| 506 a local file for each BLOB returned (up to the parameter `bloblimit`), | |
| 507 and return the filepaths of the new files in the query results. In a | |
| 508 tool like the GNOME terminal, these filepaths work as right-clickable | |
| 509 links that can open the files. | |
| 510 | |
| 511 When the \\h terminator is used to generate HTML table output, if the | |
| 512 BLOBs are images, they will be embedded as images in the generated | |
| 513 table. | |
| 281 | 514 |
| 515 | |
| 516 | |
| 517 |