Oracle

Oracle related operation Notes 1. database recovery in cold data, scenarios, including database files of all strength, including ORA, DBF, CTL files, and other logs. 10g 1. scenario 1: If the directory structure of the recovered target database and

According to the definition of NULL, NULL indicates unknown. Therefore, the results of two NULL comparisons are neither equal nor unequal, and the results are still unknown. According to this definition, the existence of multiple NULL values should

Example of creating and using oracle Stored Procedure 1. Create a stored procedureCreate or replace package pk_1 as // statement for creating a packageTYPE cur is ref cursor; // declare a pointerProcedure p1 (cr out cur );End; / Create or replace

Apart from significant technical differences between SQL Server and Oracle databases, there are also significant differences in implementation costs. I will share some of my views on this topic and hope to communicate with you. I. Oracle is

I. Backup is divided into physical backup and logical backup. 1. Physical backup is a backup of physical files (including data files, control files, and redo log files. Physical backup is further divided into hot backup/online backup and cold

Today, I used hibernate to access the oracle database and found a problem;Java code icacert IcaCaCert = icaCaCert. findByCertSerialNumber (certSerial);  An exception is reported: the stream is disabled. Looking at the database, we found that there

In previous versions, except incomplete restoration, there is usually no good solution. Currently, Oracle10g provides the new flashback drop feature to accelerate the recovery of user error operations. The flashback drop function allows you to

Any database may have certain security risks during its long-term use. For database administrators, a complete set of database backup and recovery mechanisms should not only be intended for the secure operation of computer operating systems. When

Trigger The code block automatically executed when a specific event occurs. It is similar to a stored procedure, but users cannot directly call them. Function:1. Allow/restrict table modifications2. automatically generate a derived column, such as

Database Synchronization is often used in the project process. Now, we paste the synchronization process of a project that was previously created for your reference!This document is completed in the following steps:1. Environment configuration

After Incomplete recovery, the database may not meet the recovery requirements. At this time, the database has been opened in the resetlogs mode. If the database is not fully backed up before Incomplete recovery, at this time, I want to restore some

"The cost of configuring the query optimizer is expensive, but it is worth the effort ." (Note 1) In fact, I have seen many sites that underestimate the importance of good configuration. Sometimes, I even had a heated discussion with some people who

Oracle cannot modify the data type of an existing column if there is data in the table. However, you can create a temporary column, copy the data of the column to the temporary column, delete the original column, and modify the name of the temporary

To implement conditional statistics in the count () function, use the SUM function to replace the count () function and use the SUM function to implement conditional statistics, you can use the case when statement or Decode function to convert the

Oracle memory: memory architecture: oracle database allocates memory and background processes whenever the database instance is started, the following information is stored in the memory area: program code and connection session information, even if

Create a user after creating a database in oracle [SQL]/* Step 2: Log On */log on to pl/SQL/* Step 3: create a temporary tablespace */create temporary tablespace user_temp tempfile 'e: \ oracle \ product \ 10.2.0 \ oradata \ wu \ user_temp.dbf

Oracle uses a package to package stored procedures, function stored procedures, or functions. Most developers should have used it. If the number of stored procedures or functions is small, it would be okay, if a large number of maintenance tasks are

Oracle compares two tables Comparing the Contents of Two Tables  Table A and table B. A column with the same name has different content. I have two tables named A and B. they have identical columns and have the same number of rows via select count (*

In oracle, the remainder is obtained using the mod (numer1, number2) function. In oracle, the remainder is obtained using the mod (numer1, number2) function, and the return value is the other values. For example, output 1 ~ All integer values in 13

Oracle Incremental backup script file in windows @ Set ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1 @ rem echo % ORACLE_HOME % @ set ORACLE_SID = orcl @ rem echo % ORACLE_SID % @ set NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK @ rem echo %