Oracle

I believe everyone knows about the Oracle stored procedure. The following describes how to use dynamic SQL in the Oracle stored procedure. I hope this will help you. There are two ways to use dynamic SQL for Oracle stored procedures: DBMS_ SQL or

How to deal with Oracle locks that cannot be killed: 1. The following statement is used to query which objects are locked: Select object_name, machine, s. sid, s. serial # From v $ locked_object l, dba_objects o, v $ session s Where l. object_id = o.

Steps for upgrading the ORACLE database: I. Back up ORACLE databases 2. Confirm the installation path of the Home directory of the ORACLE database 3. Shut down the database: SQLPLUS/NOLOG CONN/AS SYSDBA SHUTDOWN IMMEDIATE Stop all ORACLE running

Mistaken DeletionOracle DataThe control file of the database instance will bring a lot of trouble to the operations of the Oracle database. The following will give you a detailed explanation and hope to help you. When I backed up data two days ago,

Is DUAL a real table or is the optimizer specially processing DUAL references? Conclusion: It is a real table. See the following analysis. At the same time, according to the database creation script $ ORACLE_HOME/RDBMS/ADMIN/dcore. bsq, the

In Oracle10g, useOem toolsWhen setting database backup and recovery policies, you must provideHost ID. In fact, the host identity is the OS account of the host where Oracle is located. After entering the account name and password, a verification

InORACLEThe process in the "killed" status locks system resources for a long time and does not release the resources. There is a better way than restarting the database.Operating SystemForcibly kill those processes. 1. The following statement is

In useSDE ServiceConnectionOracle DatabaseTo avoid faults when there are many SDE users connected, SDE provides a direct connection to Oracle, that is, the connection through Oracle. This article mainly introduces some settings for SDE to directly

This article mainly introducesDBXML: A Brief Introduction to dbxml and dbxml usage. 1. What is dbxml? Dbxml is the full name of Berkeley db xml, which is developed by oracle to store xml.Database. It can be developed on multiple platforms. It

We know that any programming language can handle exceptions, such as Java and C ++.Oracle DatabaseHow to handle exceptions? In fact, the handling of Oracle Database exceptions is actually very simple. This article givesPL/SQL Exception HandlingThe

We know that database maintenance is an essential part of database security and stability. This article summarizes someOracle DatabaseSome common maintenance operations, including some common maintenance operations, some system maintenance

In Red Hat LinuxVirtual MachineInstall OnOracleThe prompt is as follows:ORA-12514Error. How can this problem be solved? This article introduces the solution to this error. Now let's take a look at this process. Solution: [Oracle @

OracleThe database must be started.Parameter file. This article summarizes the Oracle database startup parameter file and provides some SQL statements related to the startup parameter file. Let's take a look at this part. Summary of parameter files:

OracleSome files and other knowledge in the database are required. This article introduces several Oracle database files andTablespaceFor more information, see section, interval, and Oracle data block. 1. Control File Control files) Parameter file

We know that the memory structure is one of the most important parts of the Oracle architecture. According to the system's different memory usage methods, it can be dividedSystem global ZoneSGA), program global PGA), sorting Area Sort Area), Large

Last time we introduced:Oracle Database ProcessNext, let's take a look at the last Oracle process:Subordinate ProcessSlave process ). Oracle has two types of subordinate processes: I/O subordinate processes and parallel query subordinate processes.

OracleHow to Create a databaseDatabase LinkWhat about it? This article mainly introduces this part. There are two ways to create a Database Link in Oracle Database: menu and SQL. Create A dblink named dblink_name, which is connected from database A

Oracle table common query Experiment (1) Exercise 1. query all departments in the DEPT table. Select * from dept; Exercise 2. query all information of the Department number and department name fields in the DEPT table. Select deptno, dname from dept;

Oracle execution plan-processing a situation where parallel hint does not take effectOn itpub, we can see that someone is asking the question that parallel hint does not take effect. I encountered the same problem after doing the experiment, as

SQL WHERE variable IS NULL causes full table scan ProblemsToday, when reviewing the stored procedures of the project, we found that there are a large number of statements to judge whether the variable is NULL in the condition, such:SET @ SQL =