Oracle

The following articles mainly introduce the core technologies related to Oracle Database disaster protection. We all know that Oracle recovery management (RMAN) there are many functions available to help with backup and recovery processes. This tool

Recently, the new version of JDeveloper 11g has just been released. by reading the relevant Oracle documents, we found that the deployment and release methods of the ADF application have made some changes in the new version. So I want to conduct

The following article describes how to determine the location and status of the damaged redo log of an Oracle database, I hope that you will read the following articles to help you learn about the location and status of damaged redo logs of Oracle

The following articles mainly describe the summary of Oracle statement optimization rules, including the correct connection sequence in the WHERE clause and the introduction of symbols to be avoided in the SELECT clause. The following is an

We all know that Oracle 8.0 can restore and manage RMAN). It can be said that Oracle Incremental backup is implemented to a certain extent. Before RMAN development, Oracle Database output can also be incremental. However, once any part of a table

The following articles mainly describe the Oracle performance optimization skills, which will tell you what Oracle optimizer we need to choose when optimizing Oracle performance, and the type of access Table. Other shared SQL statements can be used.

Many beginners may wonder what the Oracle Cluster Index is and how to use the Oracle cluster index after getting started with Oracle databases, what is the relationship between Oracle hash clustering and Oracle clustering index. This article gives

We want to share with you today that Oracle uses the cursor. Here we need the relevant declaration. The cursor we refer to generally refers to the explicit cursor, so from now on, unless otherwise specified, the cursor we call is an explicit cursor.

Oracle fine-grained access control (VPD) is a virtual dedicated cantalua database. Its main function is to provide very powerful row-level security. Oracle fine-grained access control is launched in Oracle8i and has been widely used in various

In the past, we used Oracle-related nested tables to prevent the deletion of related elements in the middle of the array to be processed. Related array items must also be continuously processed. Oracle 10 Gb solves these two problems and adds the

The following articles mainly introduce how Oracle DRCP correctly solves the following two problems. Its shared connections can span Apache and middleware nodes, however, the shared connections are based on the relevant database users. For example,

A Complete Oracle database consists of an Oracle database instance and a database.1) databases are a collection of data files, control files, online logs, and parameter files of a series of physical files );2) an Oracle database instance is a group

The following articles mainly describe the actual application solution of the Oracle stored procedure. This article mainly uses code to introduce the actual operation of the Oracle stored procedure. The following describes the specific solution, I

We all know that we have defined in Oracle8, for the SCALAR) COMPOSITE) SCALAR) and LOB-related data Oracle data types, the following is a detailed introduction of its features, I hope it will help you in this regard. The valid scalar type is the

The following articles mainly introduce the usage of Oracle merge into and related examples. First, let's start with adding MERGE to Oracle 9I. The following is an analysis of the specific content of the article, I hope that you will be able to

The following article describes how to view and modify the maximum number of cursors in Oracle. This article describes how to use the relevant code to display and modify the maximum number of cursors in Oracle, the following is a description of the

The following articles mainly introduce the execution process of Oracle delete. We all know the specific analysis of the procedures related to the actual operations of Oracle delete and Commit, the following is an introduction to the actual

The following articles mainly describe the actual usage of the Oracle stored procedure. This article uses the actual application code to introduce the actual operation process of the Oracle stored procedure, the following is a detailed description

The following articles mainly describe the usage of Oracle to_char. Oracle to_char can be widely used in a short period of time, indicating that its practical application is dominant, the following is an introduction to the specific content of the

Oracle case usage. We all know that Oracle CASE expressions can be used in SQL to implement the if-then-else logic. PL/SQL is not required. In fact, CASE works in a similar way as DECODE (), but CASE should be used because it is compatible with ANSI.