帮助信息
help command;
查看历史记录
h;
Each entry in the history list is identified by a unique number. The !
character followed by the number of the command can be used to execute the command again. For example:
!1;
Saving and clearing the ttIsql command history
Command> savehistory history.txt;
If the output file already exists, use the -a
option to append the new command history to the file or the -f
option to overwrite the file. The next example shows how to append new command history to an existing file.
Command> savehistory -a history.txt;
You can clear the
list of commands that ttIsql
stores by using the clearhistory
command:
Command> clearhistory;
显示数据库结构信息
-
describe
- Displays information on database objects.
-
cachegroups
- Displays the attributes of cache groups.
-
dssize
- Reports the current sizes of the permanent and temporary database partitions.
-
monitor
- Displays a summary of the current state of the database.
使用 prepared statement
Command> timing 1;
Command> create table t1 (key number not null primary key, value char(20));
Execution time (SQLExecute) = 0.007247 seconds.
Command> prepare insert into t1 values (:f, :g);
Execution time (SQLPrepare) = 0.000603 seconds.
Command> exec;
Type '?' for help on entering parameter values.
Type '*' to end prompting and abort the command.
Type '-' to leave the parameter unbound.
Type '/' to leave the remaining parameters unbound and execute the command.
Enter Parameter 1 'F' (NUMBER) > 1;
Enter Parameter 2 'G' (CHAR) > 'abc';
1 row inserted.
Execution time (SQLExecute) = 0.000454 seconds.
Command> exec;
Type '?' for help on entering parameter values.
Type '*' to end prompting and abort the command.
Type '-' to leave the parameter unbound.
Type '/' to leave the remaining parameters unbound and execute the help command.
Enter Parameter 1 'F' (NUMBER) > 2;
Enter Parameter 2 'G' (CHAR) > 'def';
1 row inserted.
Execution time (SQLExecute) = 0.000300 seconds.
Command> free;
Command> select * from t1;
< 1, abc >
< 2, def >
2 rows found.
Execution time (SQLExecute + Fetch Loop) = 0.000226 seconds.
Command> disconnect;
Disconnecting...
Execution time (SQLDisconnect) = 2.911396 seconds.
Command>
分享到:
相关推荐
TimesTen学习笔记,主要对TimesTen数据源的配置、连接以及TimesTen与Oracle之间数据的交互。
NULL 博文链接:https://menglh.iteye.com/blog/299850
Oracle TimesTen 7.0 操作、管理和编程笔记
Timesten运维笔记[借鉴].pdf
最近公司打算在下一代计费系统里面使用内存数据库的技术,所以作为公司的设计人员之一的我,在oracle网上下了个TimesTen,安装在我们的测试服务器上面aix5,这篇短文主要是我操作数据库的一个笔记,下一篇打算发一个...
安装文件:otn.oracle.com Linux: red-hat ES3, SUSE9 CPU:intel EM64
Timesten下ttIsql控制台命令大全
最近用到Oracle TimesTen,网上找资料都是7.0的,现在最新的是11G,于是自己对照着英文QuickStart和手册写了一份在Linux下的安装和配置文档,记录了安装和使用过程中的一些要主意的地方。
Oracle公司下缓存数据库TimesTen,大多用于电信,金融等行业,对数据读取要求较高行业,
深度解析timesten用途,和应用场景及配置
TimesTen操作指南,不错
TimesTen Patchset 17019459 -01 Description TIMESTEN 11.2.1.9.9 RELEASE Product Oracle TimesTen In-Memory Database Release TimesTen 11.2.1.9.9
Oracle的TimesTen语法说明,不错
很好的资料关于timesten的安装
CentOS6.3安装TimesTen.docx
oracle timesten how to setup
sqldeveloper连接TIMESTEN
本文章介绍timesten的各种情况,是timesten入门的好书!
TimesTen数据库学习成果分享.doc
近期公司用到了Timesten内存数据库,但是Timesten暂不支持json,所以自己写了个包,用户数据库与json的数据转换,没什么高深的,但是要在Timesten里写也需要时间,所以分享下。 主要包括几个方面的: 1. 根据key获取...