windows sqlplus 帮助安装过程

最新推荐文章于 2024-09-24 14:34:09 发布

cuiqinxin1870

最新推荐文章于 2024-09-24 14:34:09 发布

阅读量224

点赞数

文章标签：数据库

C:>set system_pass system/oracle
Environment variable system_pass not defined

C:>helpins
ORACLE_HOME environment variable is not set

C:>set oracle_home=E:oracleproduct10.2.0db_1

C:>helpins
Set SYSTEM_PASS in the environment, then restart help installation.
SYSTEM_PASS should be set to system/pw where pw is the password
of the SYSTEM schema.

C:>set system_pass system/oracle
Environment variable system_pass not defined

C:>set system_pass=system/oracle

C:>helpins
Loading HELP data from helpus.sql

C:>sqlplus system/oracle

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 3月 8 14:14:26 2007

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring En
e options

SQL> help

HELP
----

Accesses this command line help system. Enter HELP INDEX or ? INDEX
for a list of topics. In iSQL*Plus, click the Help button to display
iSQL*Plus online help.
You can view SQL*Plus resources at http://otn.oracle.com/tech/sql_plus/
and the Oracle Database Library at http://otn.oracle.com/documentation/

HELP|? [topic]

SQL> set _editor=D:boc databaseuedit32UltraEdit-32_lh_bUedit32.exe
SP2-0735: 未知的 SET 选项开头 "_editor=D:..."
SQL> help set

SET
---

Sets a system variable to alter the SQL*Plus environment settings
for your current session. For example, to:
- set the display width for data
- customize HTML formatting
- enable or disable printing of column headings
- set the number of lines per page
In iSQL*Plus, you can also use the Preferences screen to set
system variables.

SET system_variable value

where system_variable and value represent one of the following clauses:

APPI[NFO]{OFF|ON|text} NUM[WIDTH] {10|n}
ARRAY[SIZE] {15|n} PAGES[IZE] {14|n}
AUTO[COMMIT] {OFF|ON|IMM[EDIATE]|n} PAU[SE] {OFF|ON|text}
AUTOP[RINT] {OFF|ON} RECSEP {WR[APPED]|EA[CH]|OFF}
AUTORECOVERY {OFF|ON} RECSEPCHAR {_|c}
AUTOT[RACE] {OFF|ON|TRACE[ONLY]} SERVEROUT[PUT] {ON|OFF}
[EXP[LAIN]] [STAT[ISTICS]] [SIZE {n | UNLIMITED}] [FOR[MAT
BLO[CKTERMINATOR] {.|c|ON|OFF} {WRA[PPED] |
CMDS[EP] {;|c|OFF|ON} WOR[D_WRAPPED] |
COLSEP {_|text} TRU[NCATED]}]
CON[CAT] {.|c|ON|OFF} *SHIFT[INOUT] {VIS[IBLE] |
COPYC[OMMIT] {0|n} INV[ISIBLE]}
COPYTYPECHECK {ON|OFF} *SHOW[MODE] {OFF|ON}
DEF[INE] {&|c|ON|OFF} *SQLBL[ANKLINES] {OFF|ON}
DESCRIBE [DEPTH {1|n|ALL}] SQLC[ASE] {MIX[ED] |
[LINENUM {OFF|ON}] [INDENT {OFF|ON}] LO[WER] | UP[PER]}
ECHO {OFF|ON} *SQLCO[NTINUE] {> | text}
*EDITF[ILE] file_name[.ext] *SQLN[UMBER] {ON|OFF}
EMB[EDDED] {OFF|ON} SQLPLUSCOMPAT[IBILITY] {x.y[.z]}
ESC[APE] {|c|OFF|ON} *SQLPRE[FIX] {#|c}
FEED[BACK] {6|n|ON|OFF} *SQLP[ROMPT] {SQL>|text}
FLAGGER {OFF|ENTRY|INTERMED[IATE]|FULL} SQLT[ERMINATOR] {;|c|ON|OFF}
*FLU[SH] {ON|OFF} *SUF[FIX] {SQL|text}
HEA[DING] {ON|OFF} *TAB {ON|OFF}
HEADS[EP] {||c|ON|OFF} *TERM[OUT] {ON|OFF}
INSTANCE [instance_path|LOCAL] *TI[ME] {OFF|ON}
LIN[ESIZE] {80|n} ({150|n} iSQL*Plus) TIMI[NG] {OFF|ON}
LOBOF[FSET] {1|n} *TRIM[OUT] {ON|OFF}
LOGSOURCE [pathname] *TRIMS[POOL] {OFF|ON}
LONG {80|n} UND[ERLINE] {-|c|ON|OFF}
LONGC[HUNKSIZE] {80|n} VER[IFY] {ON|OFF}
MARK[UP] HTML [OFF|ON] WRA[P] {ON|OFF}
[HEAD text] [BODY text] [TABLE text] XQUERY {BASEURI text|
[ENTMAP {ON|OFF}] ORDERING{UNORDERED|
[SPOOL {OFF|ON}] ORDERED|DEFAULT}|
[PRE[FORMAT] {OFF|ON}] NODE{BYVALUE|BYREFERENCE|
NEWP[AGE] {1|n|NONE} DEFAULT}|
NULL text CONTEXT text}
NUMF[ORMAT] format

An asterisk (*) indicates the SET option is not supported in iSQL*Plus.

SQL> set editf=notepad
SQL> ed
SP2-0107: 无须保存。
SQL> edit
SP2-0107: 无须保存。
SQL> select x from dual;
select x from dual
*
第 1 行出现错误:
ORA-06553: PLS-306: 调用 'OGC_X' 时参数个数或类型错误

SQL> edit
已写入 file =notepad.sql

1* select sysdate from dual
SQL> /

SYSDATE
--------------
08-3月 -07

SQL>

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/36779/viewspace-903454/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/36779/viewspace-903454/