Oracle

The synonyms and sequences for the basic introduction to PL/SQL PL/sql: Process language (Procedure Language) and structured language (structured Query Language)The combination of the programming language, is theSQLextensions that support multiple

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

Error example (the following error is returned when an http request is sent using UTL_HTTP ): Cause: 1. Oracle allows several PL/SQL APIs (UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP, and UTL_INADDR) to access external network services, all of which use

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

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

Today is February 6,. before the Spring Festival, I will review what I learned in October. I have detailed operations on the oracle memory segment in my previous blog. Record the usage of the ipcs command

The oracle execution plan storage outline corresponds to the SQL statement one by one. Therefore, if we change the predicate condition in the SQL statement, the storage outline will be ineffective or we need to create a new storage outline to

Problem description: Import using impdp Data Pump at ORACLE11g: ORA-01691: Lob segment ISCS. SYS_LOB0000100750C00045 $ unable to scale through 128 (in tablespace RT_DATA) There may also be insufficient TEMP and UNDO tablespaces: ORA-30036: unable to

An oracle 11GR2 javasuard switchover failover article, hoping to help you. 1. switch: the user actively switches;2. failover: the master database fails and the switchover is forced; Switchover, all physical and logical standby operations in the

After Oracle is installed, there is a default database. In addition to this default database, we can also create our own database. For beginners, you can use the 'database Configuration asmap' Wizard to create a Database to avoid troubles. After

Related commands This article mainly uses three commands. Here we will introduce them separately: Export: backs up data in the database into a binary system file. It has three modes: user mode, table mode, and whole database mode. There are also

Here we will introduce how to unlock users in Oracle. We generally use the default password to unlock users in Oracle. I hope this article will help you. 1. automatic Installation selected during installation. Because the user name and password have

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

If you have some questions about the practical application of Oracle CPU optimization, the following articles mainly introduce the practical application solutions for optimizing Oracle CPU usage using Oracle to optimize CPU usage, to solve your

In practical applications, we can feel that Oracle is quite powerful and flexible. If you want to use Oracle as a database of your project, but you do not know how to import the database, you can refer to the following articles to understand the

In actual operations, the Oracle database backup and recovery advanced options are mainly divided into two steps, including exporting multiple related fixed size files. And how to use N multiple fixed size files to import the actual operation steps.

The following articles mainly use relevant Code to introduce the actual application solution for creating and calling Oracle procedure in pl/SQL, if you want to create Oracle procedure in pl/SQL and call it, the following articles will provide you

Today we mainly discuss the installation and configuration process of the Oracle database. This article describes the actual operations in detail based on the instance description of the installation and configuration process of the Oracle database,

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