Step by Step TimesTen --- ttIsql

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

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

a. 命令列模式

1， 連線DataStore

$ ttisql -connStr fxdsn

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

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/，如需轉載，請註明出處，否則將追究法律責任。

Step by Step TimesTen --- ttIsql

相關文章