original SYS login, for example:Then go to the Lisi login cmd form to query the T table and find the newly added data. For example, with:"Summary" assumes that the data is manipulated with DML. Must commit, the ability to guarantee the real deposit in the database.(3) Data Control Language (DCL) such as: Grant, Revoke ...(4) Query language, such as: Select ...(5) Transaction Control Language (Transaction controls, TC). such as: Commit,rollback,savepoint ...Iii. Overview of Sql*plusThe 1.sql*
Use Oracle SQL * Plus to analyze SQL
I. Analyze and execute SQL statements
SQL> set autotrace on; Description: Enables automatic analysis statistics and displays the running results of SQL statements.
SQL> set autotrace traceonly; Note: Enable Automatic Analysis Statistics without displaying the running results of SQL statements. Then you can run the test SQL statement to see the analysis statistics. Genera
SQL plus and plsql cannot be used to connect to the Oracle Database System for troubleshooting and cause analysis.
Database connection problems:
Sqlplus and plsql cannot connect to Oracle 11g Database system problems or sqlplus can be connected while plsql cannot be connected.Problem 1: sqlplus cannot connect to the Oracle
After the Oracle 10g Database is installed, the web page is installed by default to manage the Oracle access path, including:
Em: http: // localhost: 1158/em
Isql * plus: http: // localhost: 5560/isqlplus and http: // localhost: 5560/isqlplus/dba
Two isqlplus websites are available, because common users and dba users log in.
To log on to isqlplus as a DBA, you mu
The isql*plus structure is as follows: The configuration process is as follows:
1 Configuration httpd
$ cd $ORACLE_HOME/Apache/Apache/conf $ vi httpd.conf 1.1 设定Server name或者Server IP地址和端口,使用非root用户启动HTTPD进程,其端口必须大于1024, 如: Listen=hpserv01:7777 1.2 设定DocumentRoot, 如DocumentRoot="/home/htdocs" 1.3 如果你也使用web server作为document content server,那么需要配置: IndexOptions NameWidth=* IndexOptions FoldersFirst AddIcon /icons/text.gif .txt .log 1.4 检查oracle_apa
Oracle Oracle's Sql*plus is a client tool that interacts with Oracle. In Sql*plus, you can run the Sql*plus command and the Sql*plus statement.
Our usual DML, DDL, and DCL statements are sql*p
SQL plus and pl/SQL cannot connect to the remote oracle database, ploracle
After the oracle client is installed, SQL plus and pl/SQL may fail to connect to the remote oracle database, which may be due to the following reasons:
Unable to connect to SQL
Troubleshooting of SQL plus logon failures caused by su switching in OracleProblem description:The oracle database in the production environment suddenly fails to log on, and the oracle database in the rlwrap production environment suddenly fails to log on. rlwrap sqlplus "/as sysdba" reports the following error: rlwrap[Oracl
Connect SQL plus to Oracle
There are three methods for SQLPlus connection.
1. sqlplus/as sysdba
Operating system authentication does not require the database server to start listener or the database server to be available. For example, if you want to start the database, you can use this method to access sqlplus and then start it using the startup command.
2. sqlplus username/password
The listener proce
Oracle SQL * plus is a client tool that interacts with oracle. In SQL * plus, you can run the SQL * plus command and the SQL * plus statement.The DML, DDL, and DCL statements we usually call are SQL *
the contents of the SQL buffer to check if your modifications are correct. Example 3-8 Sql> L Example 3-8 results Example 3-8 results table name The changes you made are accurate. So how do we run this statement?3.4 '/' (RUN) commandYou certainly do not need to reenter this statement because this statement is already in the SQL buffer. Oracle provides the Slq*plus command '/' (run) to rerun the SQL stat
Tags: ras data root Rzsz prot Ace skip Add fixSilent Installation Reference: http://www.cnblogs.com/colmeluna/p/5686142.html In the actual installation: 1. Skip the second step to set the swap area space 2. No prompt to execute orainstroot.sh after installation is complete, only root.sh Build Library Reference: http://www.cnblogs.com/jyzhao/p/4635826.html In the actual build library: 1. Only the second step is performed and the library section is manually built 2. Modify file storage path/OPT/AP
Label:1. Enter "Sqlplus/nolog" on the command line to start the tool.2. Connect to Oracle Server conn username/password @ server connection string as connection identityThe client tool connects to the server based on the server connection string, and after the connection string, the client can operate the remote database as if it were native, so the configuration of the "Server connection string" is also called the local Network service configuration,
Isql*plus Introduction
Isql*plus is a new feature offered from Oracle 9i and is a sql*plus Web form (Oracle 11g is not supported). is based on a three-tier structure. Its client, middle, and server can be located on the same machine or on a different machine. Isqlplus does
the SYS user and system user Oracle installation automatically generates SYS users and system users (1), sys user is superuser, has the highest privileges, has the SYSDBA role, has the permission to create database, the user's default password is Change_on_install (2), the system user is a management operator, and the permissions are large. With the Sysoper role, without the CREATE DATABASE permission, the default password is the manager (3generally s
Common commands and functions of Oracle SQL * plus, oracleplus
Common commands:
Connect to sqlplusRun cmd in the command line to enter. For example, to log on in sys mode, the command is as follows:(1). sqlplus "sys/zhb126 as sysdba"
(2). sqlplus/nolog connect sys/zhb126 as sysdba
(3). sqlplus scott/tiger
Start a database instance
Startup -- start the control file and data file while starting the database
S
Call the Java program in Oracle, note: The Java method must be of type static if you want to use System.out/err output log in Java.Need to execute "call Dbms_java.set_output (5000);" In Oracle.First, Helloword1 Write Java program, also write in Sql/plus, and execute.Create or replace and compile Java source named Hello aspublic class Hello {static public string Message (string name) {Return "Hello," + name;
Department groupSelect Deptno, Max (ename), Max (SAL),Min (ename), Min (Sal),AVG (SAL),Count (*), COUNT (Job), COUNT (Distinct (job)),Sum (SAL) from the EMP group by DEPTNO;2) Department 30 maximum wage, minimum wage, total number, number of jobs, number of jobs and sum of wagesSelect Deptno, Max (ename), Max (SAL),Min (ename), Min (Sal),AVG (SAL),Count (*), COUNT (Job), COUNT (Distinct (job)),Sum (SAL) from the EMP group by DEPTNO have deptno=30;3.stddev returns the standard deviation of a set
You may be running an Oracle 10g Release 2 database server, but supporting some applications may have been written very early. Data tables created prior to Oracle 8i typically have a long data type to store large text.
With the introduction of the large Object (LOB) data type, the long and long raw data types are discarded. If you are copying a data table that uses a Long data type, then using the CREATE t
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.