Simple SQL statements
Notice that some columns have been truncated to fit screen size and that screen does not
scroll endlessly. It stops after a defined number of rows to let users read records.
Just press "enter" to see next resultset part.
If you want to jump to next "n" or last "n" records, just type it !
With commands view table, index, package, procedure, segment, tablespace you can search for objects in any schema
or in one defined schema.
The % caracter can be used as standard SQL wildcard. If not given, pysql put a % before and after your search keyword.
Notice that when typing table and "tab" key, pysql complete with available commands : table and tablespace.
Pysql desc command display object and columns comments.
If table's columns are indexed it is also display with the column position in the index !
count, time, ddl, watch, shell escape, completion, history, oracle parameter search,
Pysql home page