Several cases of sqlplus and shell passing value to each otherScenario One: The simplest invocation of sqlplus in the shell$cat test.sh#!/bin/shSqlplus Oracle/[email Protected]>file.log SELECT * from Test;ExitEOF #注意EOF要顶格写$sh test.sh$cat
Help is not in sqlplus after the manual build, and the following records how to install and delete the help command in Sqlplus.
Note: The Sqlplus help command is available only when the database is open. Non-open state use help also error: Sp2-0171:
Several cases of sqlplus and shell passing value to each otherScenario One: The simplest invocation of sqlplus in the shell$cat test.sh#!/bin/shSqlplus Oracle/[email Protected]>file.log SELECT * from Test;ExitEOF #注意EOF要顶格写$sh test.sh$cat
Original works, allow reprint, please be sure to use hyperlinks in the form of the original source of the article, author information and this statement. Otherwise, the legal liability will be investigated. http://nbmonster.blog.51cto.com/1977736/665
Several cases of sqlplus and shell passing value to each otherScenario One: The simplest invocation of sqlplus in the shell$cat test.sh#!/bin/shSqlplus Oracle/[email Protected]>file.log SELECT * from Test;ExitEOF #注意EOF要顶格写$sh test.sh$cat
1, first you have to install the Oracle database server and client software, in the installation process to be aware of, select the Oracle installation directory, remember not to use the Chinese directory or a directory with
1. What is the initial password after oracle is installed?
Internal/Oracle
Sys/change_on_install
System/Manager
Scott/Tiger
Sysman/oem_temp
2. What is the initial Default User and password of Oracle9iAS Web Cache?Administrator/Administrator
3. How
Today, a strange problem has been found that the SRVCTL and Crs_start commands cannot start an Oracle RAC instance, but with Sqlplus it can start normally. The final reason for this is that the state of the database becomes disable in OCR, and this
The show and set commands are two commands for maintaining Sqlplus system variables:Sql> Show All--view all system variable valuesSql>show user--show current connected usersSql>show Error--Display errors (when compiling function,procedure,package,pl/
Show Errorshow Allshow UsersqlplusThe show and set commands are two commands for maintaining Sqlplus system variables:Sql> Show All--view all system variable valuesSql>show user--show current connected usersSql>show Error--Display errors (when
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.