How to view the usage of some commands in SQL * plus

Source: Internet
Author: User

How to view the usage of some commands in SQL * plus

Sometimes I forget the usage of some commands when using SQL * plus. In fact, we don't have to look up anything. We just need to check it in SQL * plus,

Use help |? Parameter

For example, in SQL * plus:

SQL> help column

COLUMN
------
Specifies display attributes for a given column, such:
-Text for the column heading
-Alignment for the column heading
-Format for NUMBER data
-Wrapping of column data
Also lists the current display attributes for a single column
Or all columns.

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

Where option represents one of the following clses:
ALI [AS] alias
CLE [AR]
ENTMAP {ON | OFF}
FOLD_A [FTER]
FOLD_ B [EFORE]
FOR [MAT] format
HEA [DING] text
JUS [weight] {L [EFT] | C [ENTER] | R [IGHT]}
LIKE {expr | alias}
NEWL [INE]
NEW_V [ALUE] variable
NOPRI [NT] | PRI [NT]
NUL [L] text
OLD_V [ALUE] variable
ON | OFF
WRA [PPED] | WOR [D_WRAPPED] | TRU [NCATED]

Can also be used ?, As follows:

SQL>? Show

SHOW
----
Shows the value of a SQL * Plus system variable, or the current
SQL * Plus environment. SHOW SGA requires a DBA privileged login.

SHO [W] option

Where option represents one of the following terms or clses:
System_variable
ALL
BTI [TLE]
CON_ID
CON_NAME
ERR [ORS] [{FUNCTION | PROCEDURE | package body | TRIGGER
| VIEW | type body | DIMENSION | java class} [schema.] name]
LNO
PARAMETERS [parameter_name]
PDBS
PNO
RECYC [LEBIN] [original_name]
REL [statement]
REPF [OOTER]
REPH [EADER]
SGA
SPOO [L]
SPPARAMETERS [parameter_name]
SQLCODE
TTI [TLE]
USER

The red statement is the SQL statement of the command, and the following describes some of its parameters.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.