Basic Oracle Tutorial: SQLPLUS Environment command. Commonly Used commands of sqlplus when an SQL statement is entered, SQL is cached in SQLPLUS. This cache is small and only one SQL statement can be allowed.
Basic Oracle Tutorial: SQLPLUS
This article helps you to fully understand the Sqlplus command.
Remark: Tell Sqlplus the next word is a comment, not an order.
Set Haedsep: The title separator identifies a character that tells Sqlplus to break a heading into two or more
1. Connecting Conn1.1 Login to the system with Oracle user, enter Sqlplus environment, log in Administrator mode1Oracle@yas:~>Sqlplus/Nolog2Sql*Plus:release11.2.0.1.0Production onTue Feb2 -: -: + .3Copyright (c)1982, the, Oracle. Allrights
Sqlplus Editing command line usageKeywords: Oracle sqlplus command-line usageOracle database has a lot of query tools, such as the famous plsql, accustomed to the graphical interface, and then face the character interface Sqlplus is really a torture,
1 , format the SQL Plus interface:L Overall Settings:SET Number -- set Number of rows SET Number -- set Number of columnsL single-Column settings:ColumnName for Numeber -- character class Char,varchar2, example: A10 ColumnName for 9... 9 --
2014-06-20 BaoxinjianI. Summary
If you develop a UNIX shell in Oracle EBS, it is bound to involve calling Plsql in the shell and calling Plsql in the shell typically by sqlplus this toolAbout Sqlplus need to understand Sqlplus's login and
2014-06-20 BaoxinjianI. Summary
If you develop a UNIX shell in Oracle EBS, it is bound to involve calling Plsql in the shell and calling Plsql in the shell typically by sqlplus this toolAbout Sqlplus need to understand Sqlplus's login and
1. Oracle startup and Shutdown1. to enable or disable the Oracle System in a single-host environment, you must first switch to the Oracle user, as shown below:Su-Oracle
A. Start the Oracle SystemOracle> svrmgrlSvrmgr> connect internalSvrmgr>
Oracle database has many query tools, such as the famous plsql, accustomed to the graphical interface, and then face the character interface Sqlplus really a torture, but I do not know that the immortal said "existence is reasonable."
Sometimes it
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.