$ sqlshell vspm
sqlshell, version 0.1
Copyright (c) 2009 Brian M. Clapper. All rights reserved.
Using JLine readline implementation.
? .desc database
Connected to database: jdbc:oracle:thin:@10.77.0.89:1521:scrvspm
Connected as user:     SCRUBBER
Database vendor:       Oracle
Database version:      Oracle Database 10g Enterprise Edition Release
10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
JDBC driver:           Oracle JDBC driver
JDBC driver version:   10.1.0.5.0
Transaction isolation: read committed
Open transaction?      no
? .about
sqlshell, version 0.1
Copyright (c) 2009 Brian M. Clapper. All rights reserved.
Using JLine readline implementation.
Build date: 2009/07/28 15:44:44
Built with: Scala 2.7.5
Build OS:   Mac OS X 10.4.11
? .desc TB_SCR_XREF full
-----------------
Table TB_SCR_XREF
-----------------
CID         NUMBER(10) NULL,
OTHERID     VARCHAR2(29) NOT NULL,
SOURCE      NUMBER(5) NOT NULL,
CIDTYPE     NUMBER(5) NULL,
ADDDATE     DATE NULL,
UPDATEDATE  DATE NULL,
DELETEDATE  DATE NULL

IX_SCR_XREF: Unique clustered index on (OTHERID, SOURCE)
IX1SCR_XREF: Non-unique clustered index on (CID, SOURCE)
? select count(*) from tb_scr_xref;
1 row returned.
Execution time: 10.59 seconds
Retrieval time: 0.15 seconds

COUNT(*)
--------
10399615
? select cid, otherid, source, cidtype from tb_scr_xref where rownum <= 10;
10 rows returned.
Execution time: 0.5 seconds
Retrieval time: 0.11 seconds

CID     OTHERID     SOURCE  CIDTYPE
------  ----------  ------  -------
NULL    0000000001  2       1
81070   0000000003  2       1
793962  0000000005  2       1
793963  0000000012  2       1
793964  0000000029  2       1
793965  0000000033  2       1
793966  0000000044  2       1
793967  0000000045  2       1
793968  0000000046  2       1
793969  0000000047  2       1

? .show tables tb.*xref
BAD_TB_SCR_XREF
TB_MISYS_XREF                   TB_SCR_EXTRACT_XREFCID_012_AMG
TB_SCR_EXTRACT_XREFCID_012_GSK  TB_SCR_EXTRACT_XREFCID_012_SPK
TB_SCR_EXTRACT_XREFCLL_012_AMG  TB_SCR_EXTRACT_XREFCLL_012_GSK
TB_SCR_EXTRACT_XREFCLL_012_SPK  TB_SCR_NMP_XREF_AMG
TB_SCR_NMP_XREF_GSK             TB_SCR_NMP_XREF_LOCID_AMG
TB_SCR_NMP_XREF_LOCID_GSK       TB_SCR_NMP_XREF_LOCID_SPK
TB_SCR_NMP_XREF_SPK             TB_SCR_NMP_XREF_UPDATES
TB_SCR_NMP_XTR_XREFCID_012_AMG  TB_SCR_NMP_XTR_XREFCID_012_GSK
TB_SCR_NMP_XTR_XREFCID_012_SPK  TB_SCR_NMP_XTR_XREFCLL_012_AMG
TB_SCR_NMP_XTR_XREFCLL_012_GSK  TB_SCR_NMP_XTR_XREFCLL_012_SPK
TB_SCR_SYNERGY_XREF_MERGED      TB_SCR_XREF
TB_SCR_XREF_AMG                 TB_SCR_XREF_BK
TB_SCR_XREF_BK091604            TB_SCR_XREF_GSK
TB_SCR_XREF_HISTORY             TB_SCR_XREF_HISTORY_SYN
TB_SCR_XREF_LOCID_AMG           TB_SCR_XREF_LOCID_GSK
TB_SCR_XREF_LOCID_SPK           TB_SCR_XREF_SPK
TB_SCR_XREF_STATELICENSE        TB_SCR_XREF_UPDATES
TB_SCR_XREF_VALIDATE_STLIC_AMG  TB_SCR_XREF_VALIDATE_STLIC_GSK
TB_SCR_XREF_VALIDATE_STLIC_SPK
? help
Help is available for the following commands:
-------------------------------------------------------------------------------
.about    .desc     .echo     .run      .set      .show
alter     begin     commit    create    delete    drop      exit
help      history   insert    r         rollback  select    update
? ^D
$