ttisql控制台命令大全

ttisql

控制台命令大全

由

canoe

发布于

参

考

大

全

Command>

Usage

?

Description

Print brief help

information

for

all

commands.

Executes a command

in

the

history

list.

Turns the

autocommit feature

off(0) or on(1).

!

autocommit [0|1]

Reports

information

cachegroups

on cache groups

[[cache_grou p_owner_pattern.]cache_group_name_patt

d efined in the

ern]

currently

connected

data source.

Generates

an

Oracle

SQL*Plus

compatible

script for the

installation or

uninstallation of

cachesqlget [ASYNCHRONOUS_WRITETHROUGH

Oracle objects

|INCREMENTAL_AUTOREFRESH]

associated with a

[[cache_group_owner.]cache_group_name] [filename]

cache group using

the incremental

autorefresh or

asynchronous

writethrough

feature.

clearhistory

Clears the history

buffer.

Sets

client

timeout

(in seconds) for

current

connection.

clienttimeout [timeout seconds]

close [[connect_id.]command_id] (command_id is an

Closes a result set

integer between 0 and 255 inclusive. connect_id is

on the specified

used with multiple connections)

prepared SQL

Usage

Description

statement.

Closes a result set

on all the prepared

SQL statements.

Turns the

columnlabels

feature off(0) or

on(1).

Commits

the

current

transaction.

Commits

the

current

transaction

durably.

Compacts the data

source.

Connects

to

the

data

source

specified

by

the optional DSN or

connection_string

argument.

closeall

columnlabels [0|1]

commit

commitdurable

compact

connect [DSN|connection_string] [as ]

Reports column

definitions and

describe

[[owner_name_patter n.]table_name_pattern

|

statement

procedure_name_pattern | sql_statement |

parameters

[connect_id.]command_id | *]

associated

with

the

command's

argument.

Disconnects from

the currently

connected data

source or all

connections when

the

is included.

Reports

data

source

size

information

in

kilobytes or

megabytes.

Echo the specified

message on this

line.

disconnect [all]

dssize [k|m]

e:

Usage

Description

exec [[connect_id.]command_id] (command_id is an

Executes the

integer between 0 and 255 inclusive. connect_id is

specified prepared

used with multiple connections)

SQL statement.

Executes the

specified prepared

execandfetch [[connect_id.]command_id] (command_id

SQL statement and

is

an

integer

between

0

and

255

inclusive.

connect_id

fetches all result

is used with multiple connections)

rows associated

with

the

statement.

exit

explain [plan for]

Exits the program.

Explain the plan

for .

Fetches all result

fetchall

[[connect_id.]command_id]

(command_id

is

an

rows associated

integer between 0 and 255 inclusive. connect_id is

with the prepared

used with multiple connections)

SQL statement.

Fetches one result

fetchone

[[connect_id.]command_id]

(command_id

is

an

row

associated

with

integer between 0 and 255 inclusive. connect_id is

the prepared SQL

used with multiple connections)

statement.

free [[connect_id.]command_id] (command_id is an

Frees

the

specified

integer between 0 and 255 inclusive. connect_id is

prepared SQL

used with multiple connections)

statement.

Print brief or

detailed help

information for

commands.

Lists previously

executed commands.

Executes an

operating system

command.

help [command [command...]|all|comments]

history [-r] [num_commands]

host

Reports indexes

associated

with

the

indexes [[owner_name_pattern.]table_name_pattern]

table names of all

tables

matching

the

pattern.

isolation [|]

Sets the

transaction

isolation

level

for

Usage

Description

the current

connection.

Reports the

contents of the

R table

for easy viewing.

Reports or turns on

multiple

connections.

Sets the encoding

method for native

character

input/output.

Disables(0) or

enables(1) First

Row optimization.

Reports

the

current

query optimizer

hint settings and

join order.

Sets the Oracle

Connect

passthrough

level.

Sets the prefetch

count size for the

current

connection.

monitor

multipleconnections [1|ON]

ncharencoding [ASCII|LOCALE]

optfirstrow [0|1]

optprofile

passthrough [0|1|2|3]

prefetchcount [prefetch_count_size]

prepare

[[connect_id.]command_id]

(command_id

is

an

Prepares the

integer between 0 and 255 inclusive. connect_id is

specified SQL

used with multiple connections)

statement.

Reports built-in

procedure names

that

match

the

given

pattern.

Reports

information

on replication

schemes defined in

the currently

connected data

source.

Disables(0) or

procedures [procedure_name_pattern]

repschemes

[[scheme_owner_pa ttern.]scheme_name_pattern]

retryconnect [0|1]