Oracle

In Oracle database operations, why is it that sometimes a field in a table is indexed, and when the execution plan of some language is observed, it does not go through the index? How to solve it? In this article we mainly introduce this part of the

SELECT * FROM table where id =?Similar to the above SQL, if you do not have to bind the variable, each time Oracle will be considered a different SQL, will be generated at each execution of the execution plan, and the execution plan generation is

Online migration OCR error: PROT-16 Symptom:[Root @ HeiLJUC01 ~] #/Oracle/app/11gR1/crs/bin/ocrconfig-replace ocr/dev/raw/raw9PROT-16: Internal Error[Root @ HeiLJUC01 ~] #/Oracle/app/11gR1/crs/bin/ocrconfig-replace ocr/dev/raw/raw9PROT-16: Internal

ASCII (x1) [function]: returns the ASCII value of the leftmost character of a character expression. [Parameter]: x1, character expression [Return]: Numeric [Example] SQL> select ascii ('A') A, ascii ('A') A, ascii ('') space, ascii ('shit') hz from

Some special problems in a cluster environment 1.1 Concurrency Control In a cluster environment, key data is usually shared and stored, for example, on a shared disk. Each node has the same access permission to the data. In this case, there must be

Oracle view basics and Examples Abstract: This document describes the concepts, advantages and disadvantages, application, and precautions of views.I. Concept A view is a logical table based on one or more tables or another view. Unlike tables, a

1. Introduction to exp/imp Exp/imp is the oldest two command line backup tools survived by oracle. It is widely used in small database dump, tablespace migration, table extraction, detection logic, and physical conflicts, we can use it as a logical

Applicable scenarios Imagine the following SQL Select * FromBD_INVMANDOC_bak t Where t. negallowed is null Or t. negallowed = 'n' If the negallowed column has only two values: Y and N, and NULL exists Therefore, when we create an index in the

After three hours of hard work, Oracle 12c was successfully installed on the 64-bit win8 system. This article mainly summarizes some problems encountered during the installation process for later reference. First, I will list the main configurations

1. A set of common system permissions granted by GRANT has the following three permissions: CONNECT (basic connection), RESOURCE (Program Development), DBA (Database Management) Common Data Objects have the following permissions: all on Data

1. View entries in tnsnames. ora: Bys3_dblk =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = bys3.bys.com) (PORT = 1521 )) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = bys3) ) ) In/etc/hosts, the IP address of bys3.bys.com cannot be

I. Question proposal At the early stage of application system development, due to the relatively small amount of data in the development database, the performance of SQL statement writing is not good for querying SQL statements and writing complex

During project implementation, tables are generally designed. Different from general databases, Oracle table space statement. A tablespace is the space used to store tables. When creating a table, we can create a new tablespace to store the table in

Here we will introduce the implementation process of modifying user permissions in Oracle, including some permission management aspects. I hope this article will help you understand how to modify the user permissions of Oracle. ORACLE Database User

Oracle is still quite common, So I studied the Oracle Dual table and shared it with you here. I hope it will be useful to you. Character functions include conversion functions and character operation functions. Conversion functions include LOWER,

Oracle has a lot to learn about. Here we mainly introduce Oracle 10 Gb database, including the password of the Oracle account. Linux Group and user account of Oracle 10 Gb database software. User accounts are called oracle, while groups are called

I would like to introduce Oracle to you. Many people may not know about the Oracle Sybase database. It does not matter. After reading this article, you will certainly have a lot of GAINS. I hope this article will teach you more. With the development

There are many things worth learning about in Oracle. Here we mainly introduce the character set of Oracle databases, including the national character set. Oracle Database character set (NLS supported by national languages) is used to store, process,

Standard one, standard, and enterprise are commonly used in Oracle 10 Gb operations. Do you want to know the specific differences between these three versions, the following article introduces the three frequently used versions of Oracle 10g

Initialize the parameter file -The entries in the file are dedicated to the instance to be started. -There are two types of parameters: Show: There is an entry in the file Implicit: there are no entries in the file, but it is assumed that the