view docs/source/capabilities.rst @ 268:7aa24643e358

json almost working
author catherine@dellzilla
date Wed, 18 Mar 2009 09:28:21 -0400
parents f0f293d83337
children 3c5fa8ed4f8b
line wrap: on
line source

SQLPython's extra capabilities
==============================

For the most part, SQLPython simply duplicates SQL\*Plus's capabilites.

UNIX-like commands
==================

ls
   Lists objects from the data dictionaries.  There are implied wildcards at the beginning and
   end

cat
   Shorthand for "SELECT * FROM"

PostgreSQL-like shortcuts
=========================

----- ------------------
z     y
----- ------------------
\\c   connect
\\d   desc
\\e   edit
\\g   run
\\h   help
\\i   load
\\o   spool
\\p   list
\\q   quit
\\w   save
\\db  _dir_tablespaces
\\dd  comments
\\dn  _dir_schemas
\\dt  _dir_tables
\\dv  _dir_views
\\di  _dir_indexes
\\?   help psql
----- ------------------

Wild SQL
========

Wild SQL is a nonstandard SQL feature that must be enabled with `set wildsql on`.  When it is
enabled, column names in a SELECT statement do not need to be explicitly typed.  

* % or \* as wildcards::

  SELECT d* FROM v$database;

  SELECT 

Wild SQL can only be used in the primary column list of straightforward SELECT statements, 
not in subqueries, `UNION`ed queries, etc.