Oracle

First,Operating System Installation, install Linux under VMware (OEL5.6) for the database server1. Open VMware and select "Create a new virtual machine"2. Select a Custom installation3. Select virtual machine hardware compatibility (default setting)

--like fuzzy Query, wildcard: '% ' means substituting one or more characters, ' _ ' in place of one characterSELECT * from v_test where v_name like ' _bce% ';Escape character: You can escape a wildcard ('% ', ' _ ') as a character, rather than the

I. Getting Started with SQL PlusSql*plus is one of the most commonly used tools, with strong features, mainly:1. Database maintenance, such as startup, shutdown, etc., which is generally operated on the server.2. Execute the SQL statement to execute/

Develop to a SQL to say to a condition times ORA-22922Code snippet:1 SELECTbag number,2 SUM(actual weight) asactual weight,3 SUM(Volume weight) asvolume weight,4 COUNT(waybill number)

Create schemaThis statement does not actually create a schema that automatically creates a schema when the user is created, which allows you to populate your schema with tables and views and authorization for those objects, without multiple

Group by Enhancement sql> Select Deptno,job,sum (SAL) from the EMP Group by deptno,jobsql> +sql> Select Deptno,sum (SAL) from EMP GROUP BY deptnosql> +sql> Select sum (sal) from empsql> sql> ===sql> sql> Select Deptno,job,sum (SAL) fro M EMP GROUP

Oracle Use steps: I. Oracle installation two files extracted to the same folder, Doc for description/use of document two. Oracle boot: 1. Start Oracle: Start monitoring and Custom library 2. Start Cmd->sqlplus->sys/java Login Three. Oracle operating

Today, I looked at Oracle intersection and the set, and after that I went through the search for data, after testing, organized as follows:1. and setTable 1:INSERT into student1 values (1, ' Student 1 ');INSERT into student1 values (1, ' Student 2 ')

As mentioned on the phone, OracleThe internal optimizer is based on a series of internalThe algorithm is based on statistical information on the table to generateThe line plan. For a particularly complex SQL languageOracle's optimizer has a chance

Preparation: Download3A bag1）io-tty-1.07.tar.gz2）term-readline-gnu-1.16.tar.gz3）Uniread-1.01.tar.gzInstallation:[Email protected] desktop]# TAR-XVF io-tty-1.07.tar.gz[Email protected] desktop]# TAR-XVF term-readline-gnu-1.16.tar.gz[Email protected]

1. Conversion functionsThe maximum relationship to a date operation is 2 conversion functions: To_date () To_char ()To_date () is to convert the type of the character type to a certain formatFor example: To_date (' 2016-04-15 00:00:00 ', '

　　　　1. query field name in database: Select Column_name,data_type, Data_length,data_precision,data_scale fromUser_tab_columns where table_name= ' table name '; * The table name must be uppercase.2. Querying all user information in the database:

Http://www.oracle.com/technetwork/cn/middleware/webcenter/content/downloads/oit-dl-otn-088510-zhs.html Viewer Technology 8.5.1 Release Date: 11/17/2014 The SDK renders a high-fidelity representation of the supported

This article was released under the Creative Commons licenseRecently in the study of Oracle 11gR2, writing SQL lack of demo table, studying the official information of his family found that a piece of Oracle has been prepared for US sample

SGA (System global Area), a share of the shared memory area that is shared by some of the associated processes of Oracle, is allocated in memory. such as Dbwn,pmon.The SGA is divided into the following components:1. Cache area2. Redo Log Buffers3.

Oracle recursive queries (single table with multilevel hierarchy)Http://www.cnblogs.com/walk-the-Line/p/4882866.html-- Find all child nodes under all first layers (including) select m.*,level from with='1' by = m.parent;Oracle Connect by usageHttp:

--Grade ranking tabledrop table GraderecordCREATE TABLE Graderecord (Sno VARCHAR2 (10),Sname varchar2 (20),Dormitory VARCHAR2 (5),Grade int)Partition by range (grade) (Partition Bujige values less than (60),Partition Jige values less than

　　 when you use Plsql to connect to a database after startup starts the database ,ora-12170 error occurred:Make sure to check the status of the Oracle listener using the LSNRCTL status command before starting, shutting down, or restarting the Oracle

To add a PRIMARY KEY constraint:ALTER TABLE ga_airline ADD CONSTRAINT pk_airline_id PRIMARY KEY (airline_id);There are three types of foreign KEY constraints:1. Normal FOREIGN KEY constraint (cannot delete parent table record if there is a child

Standard configuration of the Oracle listener and tnsnames file solves the problem that the listener cannot be connected. P. p1 {margin: 0.0px 0.0px 0.0px; font: 11.0px Helvetica} p. p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica;