Oracle

The most common error in Oracle RAC is that the functions and restrictions of Oracle RAC are misunderstood. The following article lists some of the most common errors in Oracle RAC. The following is an introduction to the article. Several Common

Oracle SQL injection is an old security issue. Generally, enterprise applications only focus on Java-level writing specifications, such as preparedStatement, or directly filter out dangerous characters. In fact, when compiling PL/SQL functions or

After studying Oracle for a long time, I will now share with you the test on the paging efficiency of Oracle jdbc. I hope you will surely have a lot of gains after reading this article. First, I wrote a simple jdbc paging test. In the case of 1

Principle: When the hash partition field of the data table is consistent with the partition by field in the analysis function, the data on each partition can be operated independently without interference. Therefore, the efficiency of Oracle

The following articles collect some common Oracle monitoring tools in Linux operating systems. The following articles mainly describe how to correctly use these tools to apply them, the following is a detailed description of the related tools. I

Some people say that Microsoft should cry when Oracle acquires SUN. I am very curious about the reason for this. So I went to the Internet to refer to relevant materials to analyze the main reasons, if you are curious about it, the following

This article describes the Oracle performance optimization tool, Oracle database online data dictionary, and the performance evaluation details of the Oracle Performance Optimization System, for administrators to refer to their own information

The following articles mainly start with the requests of relevant users. How does the complete working mechanism of Oracle Database work? First, if a user-related process sends a connection request, if you use the host name or the host name hit by

The following article focuses on the actual retention of the Oracle decimal point. If you have requirements for extracting the Business list, we need to use the percentage. Normally, we need to keep two decimal places for it. In fact, we can only

The following articles mainly describe the Oracle Copy command. The Oracle Copy command in SQL * Plus copies data between related human data tables, which is one of the tasks that Oracle DBA often faces, oracle provides a variety of solutions for

The following articles mainly introduce the actual application of Oracle to obtain the system date and date conversion functions, as well as how to correctly obtain the system date: SYSDATE (), and format the date: TO_CHAR (SYSDATE (), 'yy/MM/DD HH24

The following articles mainly introduce the content of Oracle 10 Gb database. We can use more updated optimizer hints to Control Optimization-related behaviors. The following describes the powerful new hints for Oracle 10 Gb database:

The following articles mainly compare SQL Server and common Oracle functions. This article mainly introduces the specific content of common functions related to mathematical functions and trigonometric functions. The following describes the specific

The following articles mainly describe the actual Oracle optimization query operations. We first assume that LARGE_TABLE is a large table), and the username column does not have relevant indexes, what statements are used in actual operations? The

Oracle Database can be used to search or operate lob data in many ways. We all know that there are four large objects in Oracle Database: lobs, the four types are blob, clob, and bfile and nclob. The following is a brief introduction to the lob data

Oracle Database indexes are the structures on disks associated with tables or views. We can retrieve rows from tables or views more quickly. Oracle Database indexes mainly contain keys generated by one or more columns in a table or related view.

Creating an Oracle package is one of the most common operations when we use an Oracle database. The following describes the syntax for creating an Oracle package. A package is a container that binds processes, functions, and data structures. A

The following describes how to import ORACLE data to a local computer from a server. If you are interested in importing ORACLE data, take a look. Grant all tables under the stat user to the mid user, that is, the mid user can access the tables under

The following describes how to implement the auto-increment oracle ID column: sequence and trigger for your reference. We hope this will help you learn about the oracle ID column. We use instances to describe the usage of the auto-increment oracle

Introduction: oracleThe system is too huge. For Beginners, it is inevitable that they will feel a little confused and want to learn everything. As a result, they will not be able to learn anything, so share their learning experience, I hope that the