Oracle

Oracle stored procedures and questions 1. the overall structure of the create or replace procedure stored PROCEDURE name (parameter 1 in number, parameter 2 in number) IS variable 1 INTEGER: = 0; variable 2 DATE; BEGINEND stored PROCEDURE name 2.

During oracle installation, the system prompts that the program Input Point getprocessimagefilenamea could not be located and solved the problem two days ago on the Dynamic Link Library PSAPI. DLL. The final success: one person has completed the

Use note amdu to recover from a hard disk fault database is a free tool provided in Oracle 11g. It is used to analyze the metadata of the ASM disk group and extract data files from an unmounted disk group. NOTE: 553639.1 Placeholder for AMDU

Rename OR relocate RNAME: 1. offline tablespace: alter tablespace users offline normal; 2. use the OS command mv to rename and re-adjust the physical location: 3. rename data file: alter tablespace users rename datafile '/u02/oracle/rbdb1/user1.dbf '

GoldenGate System 2: quick setup of a third-party one-way communication GoldenGate environment 1. Environment preparation (1) download the installation package and decompress it to ORACLE_BASE (2) modify the environment change [oracle @ irms156ogg] $

You can use the UTL_SMTP package of Oracle to send emails to the built-in UTL_SMTP package of Oracle, and find a ready-made script on the Internet. Then, some modifications are made to send emails. In the past, no supersend settings were set. After

How to Create a sequence in Oracle sequence is the so-called serial number, which is automatically increased each time it is obtained. It is generally used in places where the sequence number needs to be sorted. 1. Create Sequence you must first

The aggregate function in Oracle performs computation on a column in a group of rows and returns a single value. The aggregate function ignores NULL values. Aggregate functions are often used together with the group by clause of SELECT statements,

PMON, RECO, and ARCn PMON: processmonitor process Monitoring of oracle 10g processes performs data recovery when the user process is interrupted (abnormal. PMON is responsible for clearing the data buffer pool and releasing resources used by user

To completely delete oracle11g, follow these steps: 1. Start> set> Control Panel> Administrative Tools> stop all Oracle services. 2. Start-> Program-> Oracle-OraHome81-> Oracle Installation Products-> Universal Installer, and click "Uninstall

Custom array and Application of oracle technology ------------------ create or replace type Varchar2Varray is varray (100) of VARCHAR2 (40 ); /---------------- separated by specific symbols and stored in the array create or replace function sf_split_

Using Stored Procedures to batch export data into multiple csv files (ORACLE) databases has the following table structure: user_info (user_id NUMBER primary key, user_name VARCHAR2 (200) not null, user_age VARCHAR2 (80 ), create_date DATE,

Many times, oracle only knows the constraints to restrict some data to complete the business logic. However, it is found that there are also application latency constraints. the scenario is as follows: the inventory table uses the product ID as the

Oracle learning stored procedure (1) syntax stored procedure creation Syntax: create or replace procedure stored procedure name (param1 in type, param2 out type) as variable 1 type (value range ); variable 2 type (value range); Begin Select count (*)

Oracle Skip Locked [html] Oracle Skip Locked Oracle 11g introduces skip locked. Skip Locked is used to Skip the rows that have been Locked by other query select statements in the query select statement, and only execute the rows that can obtain the

Introduction to various background processes in oracle background processes are used to execute the actual maintenance tasks required to ensure database operation. For example, a background process maintains the buffer cache and writes blocks to

An Issue of Oracle distributed uard Broker has been studying how to build Data Guard with a Broker. It has been a good job in the past. A strange problem was suddenly found in the past two days, the configuration process is correct, but the

Three requirements for how to reasonably create an Oracle database index: Creating an index in an Oracle database is relatively simple. However, it is difficult to create an index reasonably. I believe that three appropriate indexes should be

Set up database links, Count table records, view sessions, and Max sessions. 1. SQL code select 'analyze table' | table_name | 'compute statistics; 'From user_tables where table_name like 'pr \ _ % 'escape '\' and tablespace_name = 'pr _ DATA1 '2.

SQL statements related to oracle table for deleting Foreign keys 1. find all the tables that reference a table with the primary key as the foreign key. PK_SRVMONITOR_SERVICE is the primary key name of the table. The SQL code is select c.