sqlplus example

Sqlplus cannot be initialized and sqlplus is automatically disabledFirst, install the oracle database. After installation, enter sqlplus In the cmd command window for verification. If there is something that cannot be initialized, configure it. First, find the location where you want to install oracle.F: \ oracle \ product \ 10.2.0 \ db_1 \ BIN my installation pa

Sqlplus Command Format and set Usage and interpretation in sqlplus [oracle @ oracle02 username] $ sqlplus -- helpSQL * Plus: Release 9.2.0.4.0-Production Usage: SQLPLUS [[

[Oracle]sqlplus Start parameter description# su-oracle [Grid]Usage 1:sqlplus-h | -V-H[ELP]:Displays the syntax and usage of the Sql*plus command, and then returns control to the operating system.-v[ersion]:Displays the version number of the Sql*plus, and then returns control to the operating system.Usage 2:sqlplus [[-C Set the Sql*plus command to a compatible ver

Set sqlprompt "_user ' @ ' _connect_identified>" Meaning: _user on behalf of the current login username _connect_identified connection string name, set global Sqlplus prompt in Glogin.sql user and connect identified is the sqlplus default variable Note: At this point, the Sqlplus prompt is set to take effect in all directories, @ Replace "￥/#/ can", enter

the results to the standard output .Two non-interactive ways to use Sqlplus 2Sqlplus in non-interactive mode, it can provide SQL commands from two places: the first is through the external file, but through the standard input.2.1 via external command filesqlplus username/[emailprotected]/侦听服务名 @命令文件名称 Here's an example.The command file name is called 1.sql. The contents are as follows: select count(*) from dba_objects; exit; The Run command is:

modeWhat is local mode: only in the current directory is valid, for example, we configure the Login.sql file in the current directory, then the current directory into the Sqlplus tool will load Login.sql file prompt will take effect, the other directory login does not take effect1. Create the Login.sql file in the current directoryExample Vim/home/oracle/login.sql2. Edit the Login.sql file and add a line o

example, the default value of dbms_output.put_line ('Hello sqlplus ') is OFF, to display, set it to ON 7 and Sqlprompt to set the command prompt for SQLPLUS, the default value is SQL> For example, Set sqlpromptprintout> 8. The TIME command is used to Set whether the Set time on 9 and Underline variables are displayed

username _ connect_identified connection string name. In glogin. SQL, set the global sqlplus prompt to indicate that user and connect identified are the default variables of sqlplus.Note: The setting takes effect at the sqlplus prompt in all directories. @ Replace [$/#/ all]. Entering sqlplus from another directory also loads the prompt variable.3. Save Exit4.

time sqlplus is started. Set SQLPATHAdd the SQLPATH environment variable to the ORACLE user profile file. Mine is. bash_profileFor example, export SQLPATH =/data/app/sqlpath (this path is the directory where your login. SQL is located)Of course, you can also start sqlplus and then execute the file (use the @ command ). Ii. glogin. SQLThe glogin. SQL file is a de

Original value 2:where Deptno = a New value 2:where Deptno = 20 Original value 3:and job = ' b ' New value 3:and job = ' Clerk ' Ename ---------- SMITH Adams 9. Binding variables 1) Define binding variables You can use the variable command to define a binding variable. When you use a binding variable in an SQL statement or a pl/sql block, You must add a colon to the binding variable (:). When assigning a value directly to a bound variable, you need to use the Execute command, for

Label:SELECT * FROM dept; Input order by dname; Append text command del n DELETE statement Celar buffer; command to clear the buffer Conn SYS as SYSDBA login user Typically, Sqlplus is installed by default as long as the server-side or client of Oracle is installed. Instead, SQLPLUSW just adds a form on sqlplus that executes the SQL statement exactly like Sqlplus