Oracle

Yesterday saw a post about the failure of the object recompilation problem, and then found themselves in the company also appeared inexplicable failure object.--Create an automatic compilation invalidation process transaction log table declare

Each Oracle database is comprised of three types of files: A data file, a log file, and a control file. The database's files provide true physical storage for database information.Each database has one or more physical data files. The data for a

The partition outer join implements the conversion of sparse data to dense data, for example:With T as (select Deptno, Job, sum (SAL) sum_sal from EMP Group by DEPTNO, job), TT as (select DISTINCT job from T) Select B. Deptno, A.job, sum_sal from

Ideas: The database that creates a Utf-8 instance is used as the build environment for the database. Using the PL SQL tool, the creation statement of the database is exported, executed in the Utf-8 database, and the skeleton structure of

Oracle encounters NVARCHAR2 type times wrong character set mismatch when multi-table unionFor places where nvarchar is used, add to_char (nvarchar variable or field)Such as:Select To_char (name), Price from AAUNION ALLSelect To_char (name), Price

1, database character setThe database character set consists of two character sets: the database character set and the national character set, which are specified when the database is created.1.1, querying the character set of the current

As a rookie, after completing the installation of the Oracle database, you do not know how to start. After some toss and then understand some of the reasons, summed up as follows:In fact, the Oracle database and MySQL database start are the same

The index is a powerful weapon to improve the query performance of the database.No index, like the same tag library no books, looking for books, they want to book than the sky is still difficult. , especially in the case of batch DML, the

Used to use oracle11g, a Chinese character accounted for 3 bytes, so in the operation of MySQL also has been allocated length.It's been tested today, and we found it wrong.You can see that the length of the first is really 15, but why is the second

Http://www.cnblogs.com/chen1388/archive/2010/09/25/1834827.htmlThe connect by prior recursive algorithm in OracleThe basic syntax is:Select ... from tablename start with condition 1Connect by Condition 2Where Condition 3;Cases:SELECT * FROM

Procedure1:1 CREATE OR REPLACE PROCEDUREUpdate_ac02_aae140_wyl (pi_aab001inch Number,2Po_fhz outVARCHAR2,3Po_msg outVARCHAR2) is4v_aaz159 Number( -);5 --Description: Take the condition of the old-age insured (that is, AC02), add aae140 = 410,510

Because of Oracle licensing issues, MAVEN does not provide Oracle JDBC driver, which must be manually added to the local warehouse in order to apply the Oracle JDBC driver in the MAVEN project.First, you need to download the OJDBC jar package to the

EnvironmentOperating system: Win8.1 Enterprise Oracle Development tools: PL/SQL Developer 7.0.1.1066 (MBCS)Steps to download instantclientOracle Instant Client download is available in downloads in http://www.oracle.com/cn/downloads/index.html

Create user1. First login to System user SYS (SYS user has permission to create user).2. Then write the code to create the user in the Code edit box.Syntax: CREATE USER uer_name identified by password;　　Example: Create user student identified by 1234

This article to you to explain the Latch mechanism of Oracle , Latch, with PowerWord translation is the door plug, blocking, professional terminology called latch , I began to contact when I do not understand why not write lock, not all locks? It's

package com.db;            import  java.sql.connection;      import java.sql.drivermanager;       import java.sql.PreparedStatement;      import  Java.sql.resultset;            public class  DBConnection {          //  Connect to Oracle database     

A lot of the time, we do Oracle DBA, when the application administrator informs us that now the application is very slow, the database is very slow, when we go to the database to do a few examples of select also found the same problem, some time we

Solution for Oracle installation prerequisite Check Failure[Java] installation environment: Win7-64bit Pro, Memory 6G, hard disk space enough to install the version: Oracle Database 11g Release 2 (11.2.0.1.0) for Microsoft Windows (x64) installation

Linux Oracle deletes archive logsToday encountered Oracle reported such an error: ORA-00257 to view the next, the original Oracle archiving logs are full, Solution Two One: increase the size of the archive log two: delete useless archive logs (we

Use a stored procedure to determine whether a person has stayed longer than the specified time in the travel track of a day.The stored procedure is used to determine whether a person has stayed for more than the specified time in the travel track of