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.
|
