Question

PLSQL的SQL WINDOW中不能执行的语句

请问PLSQL的SQL WINDOW中不能执行的语句有哪些？必须在Command Window下执行，例如show parameter？
我的意思是有些SQL是无法在PLSQL Developer的SQL Window下执行的，必须在Command Window命令窗口中才能执行，比如show parameter，在PLSQL Developer的SQL Window下无法执行，但在PLSQL Developer的Command Window命令窗口可以执行

呵呵，您这些是从哪个文档中找到的呢？

Answer 1

楼主的意思，我大概知道了。

其实楼主的意思，基本上就是 哪些 命令，不是标准的 SQL 命令

是 SQL Plus 所特有的命令。

清单如下:

有楼主的 “SHO[W] [option]” 哦

Alphabetic List of SQL*Plus Commands
@{url | file_name[.ext]} [arg ...]

@@ { url | file_name[.ext] } [arg ...]

/ (slash)

ACC[EPT] variable [NUM[BER] | CHAR | DATE | BINARY_FLOAT | BINARY_DOUBLE] [FOR[MAT] format] [DEF[AULT] default] [PROMPT text | NOPR[OMPT]] [HIDE]

*A[PPEND] text

ARCHIVE LOG {LIST | STOP} | {START | NEXT | ALL | integer} [TO destination]

ATTRIBUTE [type_name.attribute_name [option...]]

BRE[AK] [ON report_element [action [action]]] ...

BTI[TLE] [printspec [text | variable] ...] | [ON | OFF]

*C[HANGE] sepchar old [sepchar [new [sepchar]]]

CL[EAR] option ...

COL[UMN] [{column | expr} [option ...]]

COMP[UTE] [function [LAB[EL] text] ... OF {expr | column | alias} ...ON {expr | column | alias | REPORT | ROW} ...]

CONN[ECT] [{logon | /} [AS {SYSOPER | SYSDBA}]]

COPY {FROM database | TO database | FROM database TO database} {APPEND | CREATE | INSERT | REPLACE} destination_table[(column, column, column, ...)] USING query

DEF[INE] [variable] | [variable = text]

*DEL [n | n m | n * | n LAST | * | * n | * LAST | LAST]

DESC[RIBE] {[schema.]object[@connect_identifier]}

DISC[ONNECT]

*ED[IT] [file_name[.ext]]

EXEC[UTE] statement

{EXIT | QUIT} [SUCCESS | FAILURE | WARNING | n | variable | :BindVariable] [COMMIT | ROLLBACK]

*GET [FILE] file_name[.ext] [LIST | NOLIST]

HELP | ? [topic]

*HO[ST] [command]

*I[NPUT] [text]

L[IST] [n | n m | n * | n LAST | * | * n | * LAST | LAST]

*PASSW[ORD] [username]

PAU[SE] [text]

PRI[NT] [variable ...]

PRO[MPT] [text]

{QUIT | EXIT} [SUCCESS | FAILURE | WARNING | n | variable | :BindVariable] [COMMIT | ROLLBACK]

RECOVER {general | managed | BEGIN BACKUP | END BACKUP}

REM[ARK]

REPF[OOTER] [PAGE] [printspec [text | variable] ...] | [ON | OFF]

REPH[EADER] [PAGE] [printspec [text | variable] ...] | [ON | OFF]

R[UN]

*SAV[E] [FILE] file_name[.ext] [CRE[ATE] | REP[LACE] | APP[END]]

SET system_variable value

SHO[W] [option]

SHUTDOWN [ABORT | IMMEDIATE | NORMAL | TRANSACTIONAL [LOCAL]]

*SPO[OL] [filename[.ext] [CRE[ATE] | REP[LACE] | APP[END]] | OFF | OUT]

STA[RT] { url | file_name[.ext] } [arg ...]

STARTUP options | upgrade_options

*STORE {SET} file_name[.ext] [CRE[ATE] | REP[LACE] | APP[END]]

TIMI[NG] [START text | SHOW | STOP]

TTI[TLE] [printspec [text | variable] ...] | [ON | OFF]

UNDEF[INE] variable ...

VAR[IABLE] [variable [type]]

WHENEVER OSERROR {EXIT [SUCCESS | FAILURE | n | variable | :BindVariable] [COMMIT | ROLLBACK] | CONTINUE[COMMIT | ROLLBACK | NONE]}

WHENEVER SQLERROR {EXIT [SUCCESS | FAILURE | WARNING | n | variable | :BindVariable] [COMMIT | ROLLBACK] | CONTINUE [COMMIT | ROLLBACK | NONE]}

XQUERY xquery_statement

*Commands not available in iSQL*Plus.

Answer 2

没看懂你的意思！
sql,plsql,sqlplus是3种
show parameter 是sqlplus
你command windows下面不也要运用sqlplus才能使用sql跟plsql吗？