Oracle

The new technology is too fast, the old machine wants to install an operating system, in the development department is only the Windows 2008 installation disk, installation of Windows 2008 is very fast, and not the personnel settings, but the

        Problem Description:   A large number of external terminals access the internal UNIX server via the socket, Requires data from the server's Oracle database to be displayed in the terminal processing. The maximum number of sockets required

Oracle Parallelism (degree of parallelism) The number of slave processes that are used in parallel in the operation is the degree of parallelism dop,index&table both have DOP as default operation parallelism 1 means no parallel processing is used

For more information, see Oracle Official Documentation:Managing the Online Redo LogAdvice: Perform a database full backup prior to the following operations control file backupQuery logfile Related information:Query log file location and statusSql>

Background: There are two databases (source database, and target database), each day to the source database data synchronization to the target database, for various reasons, afraid of data loss, all synchronization 8 days before and after the data

Foreword: To prepare for a follow-up project and to use Oracle, you must first install Oracle. Native win 10 64-bit system. First step, download Oracle, official website (login registration required):Http://download.oracle.com/otn/nt/oracle11g/1

In the development process encountered a problem, that is, the primary key ID in the Oracle database data type is VARCHAR2, in the background model is a string type,Add sequence annotations to this field at this time, error: Unkonwn integral data

About OracleOracle Database, also known as Oracle RDBMS, or Oracle. is a relational database management system of Oracle Corporation. It is a leading product in the field of database. It can be said that Oracle database system is currently the world'

1, PL/SQL, full name procedure Language/sql, process-languageThe program structure of PL/SQLDeclare--declarations section (including variables, cursors, exception declarations)Begin--Statement sequence (DML statement)exception--Exception handling

Scenario Description:1, do a schema from uat to PRD migration, UAT Environment has SYS user, PRD environment without SYS user, due to restrictions, no way to use EXPDP/IMPDP, had to choose Exp/imp command;2, UAT and PRD environment TNS has been

2018-07-1216:41:191 Six, anonymous block2 1, define anonymous blocks:3 Declare 4Definition section;---optional Section5 begin6Executive section;---Required Section7 Exception8Exception handling Section;---optional Section9 End;Ten One ---Output

1. Check the installation packageYum-y install gcc make binutils gcc-c++ compat-libstdc++-33 elfutils-libelf-devel elfutils-libelf-devel-static Elfutils-libelf-devel ksh libaio libaio-devel numactl-devel sysstat UnixODBC unixodbc-devel pcre-devel2.

Excerpt from: https://www.cnblogs.com/wangzhuxing/p/7727713.htmlSQL Duplicate record query1, look for redundant records in the table, duplicate records are based on a single field (Peopleid) to determineSELECT * from Peoplewhere Peopleid in (select

1. Create an increment sequenceCREATE SEQUENCE id_add (sequence name)INCREMENT by 1START with 1MINVALUE 1Nomaxvalue;2. Create a trigger to bind to the tableCreate or Replace trigger Id_add_tri (trigger name)Before insert on bi_provincename (table

Suppose there is a student table student, the student table has a name, a score, a course number, and now I need to sort the students ' grades according to the course.SELECT * FROM Student1. Rank over () can be achieved on the student rankings,

Tidy up the sort:To build a table statement:CREATE TABLE EXAM(Name VARCHAR2 (32),Subject VARCHAR2 (32),Score INTEGER)Data:INSERT into EXAM VALUES (' Zhao Liu ', ' math ', ' 71 ');INSERT into EXAM VALUES (' Zhang San ', ' math ', ' 81 ');INSERT into

1. Command line ParametersFor example: Exp scott/[email protected] tables=emp file=d:\test.dmp2. Interactive promptFor example: C:\users\administrator>exp + ENTEREnter user name, carriage returnInput password, enterEnterEnter the path of the

Oracle Data Pump Export Demo steps1. Create a directory with Oracle usersmkdir Software_bak[Email protected] ~]$ CD software_bak/[Email protected] software_bak]$ pwd/home/oracle/software_bak2. set up the catalogue and authorizeSql> Show user;USER is

1. About number type.Here's a short excerpt from its documentation:P is the precision, or the total number of significant decimal digits, where the most significant digit is the left-most n Onzero Digit, and the least significant digit is the

Practice I. Name, salary, department name, number of departments of employees who have paid more than the salaries of all employees working in department 30Think steps: 1, determine the data tables you need to use         I. EMP: employee's name,