Step by Step TimesTen --- ttIsql

 

ttIsql是TimesTen的一個互動工具，相當於oracle的sqlplus.

ttIsql有兩種模式，一種是命令列互動，一種是批處理模式。

 

a. 命令列模式

 

1， 連線DataStore

$ ttisql -connStr fxdsn

 

Copyright (c) 1996-2007, Oracle.  All rights reserved.

Type ? or "help" for help, type "exit" to quit ttIsql.

All commands must end with a semicolon character.

 

connect "fxdsn";

Connection successful: DSN=fxdsn;UID=times;DataStore=/ora/TimesTen/datastore/fxdsn;DatabaseCharacterSet=US7ASCII;ConnectionCharacterSet=US7ASCII;PermSize=8;TempSize=8;TypeMode=0;

(Default setting AutoCommit=1)

Command>

 

2，察看資料庫中有哪些表

 

Command> select TBLNAME,TBLOWNER from sys.tables;

 

< TABLES                         , SYS                             >

< COLUMNS                        , SYS                             >

< INDEXES                        , SYS                             >

< TBL_STATS                      , SYS                             >

< COL_STATS                      , SYS                             >

< PLAN                           , SYS                             >

< MONITOR                        , SYS                             >

< CACHE_GROUP                    , SYS                             >

< TRANSACTION_LOG_API            , SYS                             >

< VIEWS                          , SYS                             >

< SEQUENCES                      , SYS                             >

< TTABLES                        , SYS                             >

< TINDEXES                       , SYS                             >

< TTBL_STATS                     , SYS                             >

< TCOL_STATS                     , SYS                             >

< DUAL                           , SYS                             >

< TABLE_HISTORY                  , SYS                             >

< COLUMN_HISTORY                 , SYS                             >

< SYNONYMS                       , SYS                             >

< SYS_ACC_RIGHT                  , SYS                             >

< OBJ_ACC_RIGHT                  , SYS                             >

< USERS                          , SYS                             >

< REPELEMENTS                    , TTREP                           >

< REPLICATIONS                   , TTREP                           >

< REPPEERS                       , TTREP                           >

< REPSTORES                      , TTREP                           >

< REPSUBSCRIPTIONS               , TTREP                           >

< REPTABLES                      , TTREP                           >

< TTSTORES                       , TTREP                           >

< REPNETWORK                     , TTREP                           >

< XLASUBSCRIPTIONS               , SYS                             >

< TEST                           , TIMES                           >

 

32 rows found.

 

3，檢視錶結構

Command> desc test;

 

Table TIMES.TEST:

  Columns:

    A                               NUMBER (38)

 

1 table found.

(primary key columns are indicated with *)

 

4， 執行SQL語句

Command> select * from test;

0 rows found.

Command> insert into test values(1);

1 row inserted.

Command>  insert into test values(2);

1 row inserted.

Command> select * from test;

< 1 >

< 2 >

2 rows found.

 

5，執行一個SQL檔案

Command> run test.sql

 

insert into test values(3);

1 row inserted.

 

insert into test values(4);

1 row inserted.

 

 

b. 批處理模式

 

$ ttisql -f test.sql fxdsn

 

Copyright (c) 1996-2007, Oracle.  All rights reserved.

Type ? or "help" for help, type "exit" to quit ttIsql.

All commands must end with a semicolon character.

 

connect "DSN=fxdsn";

Connection successful: DSN=fxdsn;UID=times;DataStore=/ora/TimesTen/datastore/fxdsn;DatabaseCharacterSet=US7ASCII;ConnectionCharacterSet=US7ASCII;PermSize=8;TempSize=8;TypeMode=0;

(Default setting AutoCommit=1)

 

run "test.sql";

 

insert into test values(3);

1 row inserted.

 

insert into test values(4);

1 row inserted.

 

exit;

Disconnecting...

Done.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/81/viewspace-205093/，如需轉載，請註明出處，否則將追究法律責任。