|
247
|
1 SQLPython's extra capabilities
|
|
|
2 ==============================
|
|
|
3
|
|
|
4 For the most part, SQLPython simply duplicates SQL\*Plus's capabilites.
|
|
|
5
|
|
|
6 UNIX-like commands
|
|
|
7 ==================
|
|
|
8
|
|
|
9 ls
|
|
|
10 Lists objects from the data dictionaries. There are implied wildcards at the beginning and
|
|
|
11 end
|
|
|
12
|
|
|
13 cat
|
|
|
14 Shorthand for "SELECT * FROM"
|
|
|
15
|
|
|
16 PostgreSQL-like shortcuts
|
|
|
17 =========================
|
|
|
18
|
|
|
19 ----- ------------------
|
|
|
20 z y
|
|
|
21 ----- ------------------
|
|
|
22 \\c connect
|
|
|
23 \\d desc
|
|
|
24 \\e edit
|
|
|
25 \\g run
|
|
|
26 \\h help
|
|
|
27 \\i load
|
|
|
28 \\o spool
|
|
|
29 \\p list
|
|
|
30 \\q quit
|
|
|
31 \\w save
|
|
|
32 \\db _dir_tablespaces
|
|
|
33 \\dd comments
|
|
|
34 \\dn _dir_schemas
|
|
|
35 \\dt _dir_tables
|
|
|
36 \\dv _dir_views
|
|
|
37 \\di _dir_indexes
|
|
|
38 \\? help psql
|
|
|
39 ----- ------------------
|
|
|
40
|
|
|
41 Wild SQL
|
|
|
42 ========
|
|
|
43
|
|
|
44 Wild SQL is a nonstandard SQL feature that must be enabled with `set wildsql on`. When it is
|
|
|
45 enabled, column names in a SELECT statement do not need to be explicitly typed.
|
|
|
46
|
|
|
47 * % or \* as wildcards::
|
|
|
48
|
|
|
49 SELECT d* FROM v$database;
|
|
|
50
|
|
|
51 SELECT
|
|
|
52
|
|
|
53 Wild SQL can only be used in the primary column list of straightforward SELECT statements,
|
|
|
54 not in subqueries, `UNION`ed queries, etc. |
