sqlplus example

1. What is sqlplus? Sqlplus is an interactive tool for batch query. Sqlplus is installed for each oracle database. Sqlplus works in the command line mode. SQL * Plus has its own command set and environment. Sqlplus provides users with a way to access the database.

sqlplus and dB to achieve better performance. In addition, you do not need to write a password when writing the database string. sqlplus will prompt you to enter the password later. A complete example: Sqlplus/nolog SQL> set arraysize 5000 SQL> copy from serol/LUO @ mescp to serol/LUO @ ractest create test_copy_table

Common commands:Connection SqlplusCommand line to run CMD entry, such as logging in the SYS mode, the command is as follows:(1). Sqlplus "sys/zhb126 as SYSDBA"(2). Sqlplus/nolog Connect sys/zhb126 as Sysdba(3). Sqlplus Scott/tigerStart a DB instanceStartup-Start the database while starting the control files, data filesStartup Mount-Starts the control file and doe

In windows, sqlplus is completely normal, but in linux, there is a problem with sqlplus Chinese display, always displaying "?", How can this problem be solved?The solution is as follows:In fact, it is easy to set exit sqlplus and set the corresponding environment variable NLS_LANG.Export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"In order not to reset it next

In Windows, sqlplus is completely normal, but in Linux, there is a problem with sqlplus Chinese display, always displaying "?", How can this problem be solved? The solution is as follows: In fact, it is easy to set exit sqlplus and set the corresponding environment variable NLS_LANG. Export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK" In order not to reset it n

Edit the SQL statement in the current SQLPLUS Buffer For example, ed is short for editing the SQL statements in the buffer zone using the editor specified by our environment variables. Of course, it is the buffer zone of SQLPLUS. We can prove that, when we have no connected database, we can also use EDIT to EDIT it. If you want to modify the Default Editor, for

Enter "sqlplus/as sysdba" in the Command window and press enter to connect to Oracle, for example, C: \> sqlplus/as sysdba SQL * Plus: release 11.2.0.1.0 Production on Tuesday April 17 10:05:34 2012 Copyright (c) 1982,201 0, Oracle. all rights reserved. connect to www.2cto.com: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionWith the Partition

Windows sqlplus/assysdba report the ultimate solution of ora-12560Windows sqlplus/as sysdba report the ultimate solution of ora-12560Windows, sqlplus/as sysdba often report ORA-12560: TNS: protocol adapter error, solve this error, there are multiple methods: 1. Verify that the ORACLE_HOME key and its key value in the windows registry are correct and valid.For

) patch set, for example, update to 10.2.0.4;3) apply a temporary patch 4612267 to the bug.The first method does not completely solve the problem and will remain the same later. The second method requires a long upgrade time and a long database suspension. The current production environment is not suitable for the time being;Reference:Doc ID: 338461.1 SQL * Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of TimeDoc ID: 4612267.8 Bug 4612267-OCI

A few days ago, Oracle 10 Gb was installed on RedHat AS 4.1. It was always reported during database creation:ORA-12154: TNS: cocould not resolve service name. I don't know why, so I went to the Internet to search for solutions. For every possible reason, I tried it. Oracle had no more than 10 words in 10 Gb. I was busy that night until AM. I tried all possible causes. The last struggle last night was really unmeasurable. Sometimes the solution to the problem is a matter of instant. You can say t

Sometimes you may use SQLPLUS spool table data. How can you speed up the spool? SQLPLUS has a row prefetch Option In SQLPLUS, the default arraysize is 15. SQL> show arraysizeArraysize 15 It indicates that only 15 rows of records are transferred from the Oracle server to the client (SQLPLUS) at a time. Of course, JDBC a

Connection errorafter installation, I log in to the Enterprise background (HTTP://UBUNTU:1158/EM) error, with Sqlplus connection Oracle also error.One, the error encountered is as follows1,ora-12505:tns:listener does not currently know of SID given in Connect descriptor (DBD Error:ociserverattach)2,ora-28547:connection to server failed, probable Oracle Net admin error (DBD error:ocisessionbegin)3,sqlplus:error while loading shared libraries:libsqlplus

Cat echo_time #!/bin/sh"sys/unimas as Sysdba" Select to_char (sysdate,'yyyy-mm-dd') today from Dual;exit;! [email protected] shell_test]$.Operation Result:TODAY-----------Geneva--S is silent mode, does not output similar "sql>", connect the database, close the database and other information.EofEOF can be any string such as "Laldf" then when you enter a single line Laldf "The shell thinks the input ends, but must indicate that the block must start with Start and end to match this symbol "

Oracle Note (ii) sqlplus commandFor Oracle database operations, the command line is used primarily, and all commands are done using sqlplus, and there are two forms for sqlplus. One is the sqlplus:sqlplus.exe of DOS style; The other is the Windows-style sqlplus:sqlplusw.exe; The main use of the Oracle 10g is the SQLPLUSW command, as it can make

Label:Several cases of sqlplus and shell passing value to each other Scenario One: The simplest invocation of sqlplus in the shell $cat test.sh #!/bin/sh Sqlplus Oracle/[email Protected]>file.log SELECT * from Test; Exit EOF #注意EOF要顶格写 $sh test.sh $cat File.log --Omit a number of system prompt information------- Sql> EMPNO EmpName SAL DEPTNO -------------------

Sqlplus spool to dynamic log file name through the sqlplus spool function we output the results of routine database O M to the log file, and sometimes it needs timed output, in order to avoid repeated log file names, the output log file name can be dynamically named. This article provides an example for your reference. Www.2cto.com 1. The script for generating d

Sqlplus command User Guide Sqlplus command User Guide (1)Anyone familiar with Oracle knows that SQL plus is an important tool for dealing with Oracle. SQL plus itself has many commands that can help us do many things, including generating standardized reports and providing human-computer interaction. Below, I will briefly describe it for your reference:1. Help commandsHelp helps us find the usage of each S

[Oracle 10g] sqlplus logon error resolved, oraclesqlplus I,When running sqlplus in cmd in win7, the following error is reported: SP2-1503: Unable to initialize Oracle call interface SP2-1503: Unable to initialize Oracle call SP2-0152 Solution: In the oracle \ product \ 10.2.0 \ db_2 \ BIN directory, find sqlplus.exe, right click --- properties --- compatibility --- choose to run this program in XP SP3

WHERE dname = UPPER (' dept ');Original Value 1:select * FROM dept WHERE dname = UPPER (' dept ')New Value 1:select * FROM dept WHERE dname = UPPER (' Sales ')DEPTNO dname LOC———- ————– ————-SALES CHICAGOE, custom Sql*plus environmentUse the SET command to control the current session.Syntax: SET system_variable valueEg, sql> set arraysize 20;You can use the show command to view set settings.eg, sql> show arraysizeArraySize 20Description: For the SET command, see "The Oracle SET command in detai

1 Sqlplus Login Log on locally (log on to the database server) Oracle Login Sqlplus account name/password as role name 1.1 SYS Login Example: Sqlplus sys/oracle ERROR: Ora-28009:connection as SYS should be as SYSDBA or sysoper SYS administrator must have role sysdba 650) this.width=650; "title=" clip_image002 "style="