SQL * Plus help manual for SP2-0171)

For masters who often work under SQL * Plus, they always query the help commands of SQL * Plus from time to time. It's too much to remember. The Help Command is provided in SQL * Plus to help describe the usage of all commands. Hey, you no longer need to check SQL * Plus reference. By default, the help manual for SQL * Plus is not installed for Oracle 10 Gb, and must be manually installed. The same installation method is used in Oracle 10/11G. The following describes how to install and use help.

 

1. Install sqlplus help

System @ cnmmbo> help SP2-0171: Help system not available. Robin @ szdb: ~> CD $ ORACLE_HOME/sqlplus/admin/help -- the script path is in ORACLE_HOME, and in the sqlplus/admin/hlep directory, Robin @ szdb: /users/Oracle/orahome10g/sqlplus/admin/help> lshelpbld. SQL helpdrop. SQL helpus. SQL hlpbld. sqlrobin @ szdb:/users/Oracle/orahome10g/sqlplus/admin/help> head-40 hlpbld. SQL ---- copyright (c) Oracle Corporation 1983,200 3. all rights reserved. ---- name -- hlpbld. SQL ---- description -- builds the SQL * Plus help table and loads the help data from a -- data file. the data file must exist before this script is run. ---- usage -- to run this script, connect as system and pass the datafile to be -- loaded as a parameter e.g. ---- sqlplus system/<system_password> @ hlpbld. SQL helpus. SQL ---- define datafile = & 1 ---- create the help table -- drop table help; Create Table Help (topic varchar2 (50) not null, seq number not null, info varchar2 (80 )) pctfree 0 storage (initial 48 k pctincrease 0); grant select on help to public; ---- Insert the data into help. -- @ & datafilesystem @ cnmmbo> @ $ ORACLE_HOME/sqlplus/admin/help/hlpbld. SQL helpus. sqlddrop table help * error at line 1: ORA-00942: Table or view does not existtable created. grant succeeded .... commit complete. view dropped.

2. Help manual usage

-- Check that the created table has already added row 978 system @ cnmmbo> select count (*) from help; count (*) ---------- 978 -- enter help directly at the command prompt, SQL * Plus help usage: Help |? [Topic] -- Help Index or? Index lists all available commands in sqlplus: system @ cnmmbo> 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] -- switch to another account to test whether help is available system @ cnmmbo> conn goex_admin/xxxxxconnected. -- Other accounts can also be used for the test below, because a view is created at creation and the select permission is granted to other users. goex_admin @ cnmmbo> help indexenter help [Topic] for help. @ copy pause shutdown @ define print spool/del prompt sqlplus accept describe quit start append disconnect recover startup archive log edit remark store attribute execute repfooter timing break exit repheader ttitle btitl E get reserved words (SQL) undefine change help reserved words (PL/SQL) variable clear host run whenever oserror column input save whenever sqlerror compute list set connect password show -- view the specific usage of each command -- help <command> or? <Command> goex_admin @ cnmmbo> help define ------ specifies a substitution variable and assigns a char value to it, or lists the value and variable type of a single variable or all variables. def [ine] [variable] | [variable = text] -- Author: Robinson -- Blog: http://blog.csdn.net/robinson_0612goex_admin@CNMMBO> help ACCEPT ------ reads a line of input and stores it in a given substitut Ion variable. in iSQL * Plus, displays the input required screen for you to enter a value for the substitution variable. ACC [EPT] variable [num [ber] | char | date | binary_float | binary_double] [for [Mat] format] [DEF [ault] default] [prompt text | nopr [OMPT] [hide] -- with it, you don't have to worry about unremembered commands any more.

More references

DML error logging

PL/SQL --> cursor

PL/SQL --> implicit cursor (SQL % found)

Batch SQL forall statements

Bulk collect clause for batch SQL

Initialization and assignment of PL/SQL Sets

PL/SQL Union arrays and nested tables
PL/SQL variable-length Array
PL/SQL --> PL/SQL records

SQL tuning steps

Efficient SQL statements

Parent cursor, child cursor, and shared cursor

Bind variables and their advantages and disadvantages

Use of the display_cursor function of dbms_xplan

Use of the display function of dbms_xplan

Description of each field module in the execution plan

Use explain plan to obtain the SQL statement execution plan