Oracle

The following is a detailed description of Oracle-related remote replication and Remote Disaster Tolerance, the following technologies or solutions are available for remote replication and Disaster Tolerance Related to Oracle databases. I hope you

The Oracle database system is very huge. For some beginners, I always feel that I don't know how to learn from it. I want to learn a lot, but it is hard to learn, so today, I want to share my learning experience with everyone. I hope that those who

The following articles mainly introduce the actual operation steps for implementing top N in Oracle. We all know that the select top statement is not supported by Oracle, therefore, we often use the combination of order by and ROWNUM in Oracle to

After learning about Oracle for a while, we may encounter Oracle data import problems. Here, we will briefly introduce some Oracle data import methods and share them with you. The Oracle Data Import utility allows you to extract data from a database

In actual Oracle Applications, online backup mainly requires the ARCHIVELOG-related mode, which is mainly used to execute the actual application and operations of Oracle data. For example, in an online store, the Oracle database must be open

This article mainly introduces the Oracle database type LONG. We all know that the storage in the LONG data type can change the LONG string, and the maximum length limit is 2 GB. The following articles mainly describe the types of Oracle

The following article mainly introduces the Oracle data file size restriction solution. We all know that the size of the racle data file is limited to an internal one. The related limitation is: each related data file can contain a maximum of 2 ^ 22-

My personal understanding of the temporary Oracle table is to create a table in the Oracle database. Its main function is to use it in its own software system, if you run out, you will find that some data in the relevant table is useless. Oracle

The following articles mainly introduce the Oracle data import tool IMP. We all know that the import table is the tool IMP used to reload the table structure and related data of the file in EXP to the Oracle database, the TABLES option is used to

The following article describes the actual application of the update statement in Oracle multi-Table Association, we have established the following simple model and constructed part of the test data: in a business acceptance subsystem BSS, Customer

The following articles mainly describe the actual operating scheme for collecting SQL tracking information in the Oracle process. In the actual operating process of the relevant database system performance diagnosis, we generally use SQL statements

We all know that in addition to the built-in DBCA, Oracle can create databases. In addition, there is another way to create a database, that is, manually create a database in Oracle, this is what DBAs must master. The following describes how to

The following articles mainly introduce the concept of Oracle Character Set and the introduction of how to view and correctly modify the Oracle character set, as well as how to correctly view the Oracle character set in actual operations.Database

Today we are going to discuss with you two examples of Oracle for in loop. I saw the relevant information about the two examples of Oracle for in loop on the relevant website two days ago, I think it will be helpful to the computer community in

We all know that garbled characters often occur in the actual operations of Oracle PL Developer. This problem has always plagued us and we hope to find a useful solution, the following article describes how to solve the Chinese garbled characters of

The following articles mainly describe the actual usage of Oracle trunc () functions. This article mainly talks about TRUNC (for dates) and TRUNC (for number, if you are interested in the actual usage of the Oracle trunc () function in actual

There are many things worth learning about in Oracle Database. In this article, we mainly talk about the Oracle SMON process, mainly about archive process ARCH and other aspects. We all know that there are two very small processes in the Oracle

The following articles mainly introduce the five specific requirements of Oracle Database in design standardization. Today we mainly introduce the first two requirements, we should avoid empty columns in the table, and avoid repeated values or

The following articles mainly describe Oracle paging statements. The following articles mainly describe the actual operation steps of Oracle paging statements through the actual application code of Oracle paging statements, the following describes

Oracle random number generation function can return a random number between 0 and 1. This function has good practical value. Let's take a look at the usage of Oracle random number generation function. Oracle8 version 8.0 introduces the DBMS_RANDOM