資源描述：
《ttisql控制臺命令大全》由會員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。
1、ttisql控制臺命令大全由canoe發(fā)布于參考大全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
