Oracle

The control file is one of the primary files that make up Oracle database, documenting the binary files of the physical structure of the Oracle databases, mainly including the following:Database nameData files and redo log file location

In previous versions, the parent table could not be truncate directly when there was a foreign key constraint. In 12C, a cascade operation attribute was added to the truncate operation.If you create a FOREIGN key constraint, use "on Delete

This problem encountered many times, every time the system was met once, but always take half a day to fix.Today it takes a couple of hours to settle, and finally a clear understanding must be recorded.One, download decompression, do not build any

In 12C, multiple indexes can be created on the same set of columns, but the types of multiple indexes are different. At the same moment, only one is visible. as Select from EMP; SQL> CREATE INDEX emp_tab_ix_01 on Emp_tab (job,hiredate); -- before

Character IP to numeric conversion:1 Create or Replace functionF_ip2number (v_ipinch varchar2)return Number is2I Number;3 begin4I=Regexp_substr (V_IP,'(\d{1,3})',1,1)*16777216 5 +Regexp_substr (V_IP,'(\d{1,3})',1,2)*655366 +Regexp_substr

rownum and rowID are pseudo-columns, but the root of the two is different, rownum is to assign a logical number to each row based on the results of the SQL query, so your SQL will result in a different final rownum, but rowID is physically

Environment:Operating system: redhat6.4 64-bitDatabase version: 10.2.0.4 64-bitBuild test Reason: http://718693.blog.51cto.com/708693/1682945Description: Install 10.2.0.1 64-bit on redhat6.4 and then upgrade to 10.2.0.4 64-bit, in the execution DBCA

PL/SQL has three types of exception errors1. Pre-defined errorsOracle has approximately 24 predefined exception errors that are not defined in the program and are automatically raised by Oracle.2. Non-predefined errorsOther standard Oracle errors

[SQL]View Plaincopy /* Inquire: Select job,broken,what,interval,t.* from user_jobs t; Unique identifier of the job job, automatically generated Whether the broken is in a running state, N; run; Y: Stop What stored procedure name

Oraclewindow functions in supportrow_number (), its usage andMSSQLServer2005in the same way as weperform the followingSQLstatement:SELECT * from(SELECTrow_number () over (ORDER byfsalaryDESC) Row_num,Fnumber,fname,fsalary,fage fromT_employee)

Sys_guid ()-Unique indexIn Oracle, you can use Sys_guid () to generate a GUID that is equivalent to NEWID () in MSSQL.The resulting data in oracle9i and Oracle 10g is 32 bits, such as: 234E45F0077881AAE0430AA3034681AAHowever, the GUID in Oracle is

First of all, because many friends in the group said QTP connect Oracle a bit of a hassle, I do a complete tutorial for connecting to Oracle, I hope that the need to learn friends can look at the following: 1, no matter what language, connect Oracle

First of all, because many friends in the group said QTP connect Oracle a bit of a hassle, I do a complete tutorial for connecting to Oracle, I hope that the need to learn friends can look at the following:1, no matter what language, connect Oracle

(1) Installation of dependent packagesInstalling Oracle under Linux, in addition to the system configuration parameters, I think the installation of dependent packages is another trivial operation.This installation has encountered several package

Tom the Great God wrote a to view the use of Oracle database object space.The following shows how to use:– Tool SourceCREATE ORREPLACEprocedure show_space (p_segname in VARCHAR2,

1,problem description,DBCAfinallyFinishwhen the errorora-00119:invalid Specification for system parameter Local_listener ora-00130:invalid LISTENER address ' (address= (P ROTOCOL=TCP) (host=pldb236) (port=1521)) ', as shown in2, GohostsAdd

Oracle -- Transaction, oracletransaction Transaction: A transaction is a group of related operations performed as a single logical unit of work. All or all of these operations are required to be completed. Reason for using transactions: ensure data

Oracle Performance Optimization The ORACLE tutorial is: Excellent Oracle performance. Increasing the SGA buffer seems to have not significantly improved the performance, and the loading time has only increased by 1.73%. Next we will increase the

Difficulties and key points encountered during the installation of OracleRAC (2) (1) install dependency packages In addition to system configuration parameters, installing Oracle in Linux is another Trivial operation. This installation encountered

How to optimize real-time Oracle databasesBackground of optimization ideas for real-time Databases There are about 168 heat exchange station units, each of which has nearly 400 points, and more than 60 thousand points need to be updated in real time.