ttisql控制台命令大全

《ttisql控制台命令大全》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、ttisql控制台命令大全由canoe发布于参考大全Command> UsageDescription?Printbriefhelpinformationforallcommands.!Executesacommandinthehistorylist.autocommit[0

2、1]Turnstheautocommitfeatureoff(0)oron(1).cachegroups[[cache_group_owner_pattern.]cache_group_name_pattern]Repor

3、tsinformationoncachegroupsdefinedinthecurrentlyconnecteddatasource.cachesqlget[ASYNCHRONOUS_WRITETHROUGH

4、INCREMENTAL_AUTOREFRESH][[cache_group_owner.]cache_group_name][filename]GeneratesanOracleSQL*Pluscompatiblescriptfortheinstallationoruninstallati

5、onofOracleobjectsassociatedwithacachegroupusingtheincrementalautorefreshorasynchronouswritethroughfeature.clearhistoryClearsthehistorybuffer.clienttimeout[timeoutseconds]Setsclienttimeout(inseconds)forcurrentconnection.close[[connect_id.]command_id](

6、command_idisanintegerbetween0and255inclusive.connect_idisusedwithmultipleconnections)ClosesaresultsetonthespecifiedpreparedSQLstatement.closeallClosesaresultsetonallthepreparedSQLstatements.columnlabels[0

7、1]Turnsthecolumnlabelsfeatureoff(0)oron(1).co

8、mmitCommitsthecurrenttransaction.commitdurableCommitsthecurrenttransactiondurably.compactCompactsthedatasource.connect[DSN

9、connection_string][as]ConnectstothedatasourcespecifiedbytheoptionalDSNorconnection_stringargument.describe[[owner_name_pattern.

10、]table_name_pattern

11、procedure_name_pattern

12、sql_statement

13、[connect_id.]command_id

14、*]Reportscolumndefinitionsandstatementparametersassociatedwiththecommand'sargument.disconnect[all]Disconnectsfromthecurrentlyconnecteddatasourceorallconnectionswhenthe"a

15、ll"argumentisincluded.dssize[k

16、m]Reportsdatasourcesizeinformationinkilobytesormegabytes.e:Echothespecifiedmessageonthisline.exec[[connect_id.]command_id](command_idisanintegerbetween0and255inclusive.connect_idisExecutesthespecifiedpreparedusedwithmul

17、tipleconnections)SQLstatement.execandfetch[[connect_id.]command_id](command_idisanintegerbetween0and255inclusive.connect_idisusedwithmultipleconnections)ExecutesthespecifiedpreparedSQLstatementandfetchesallresultrowsassociatedwiththestatement.exitExi