Oracle

Oracle process structure classification three processes: User process, service process, background process user process: oracle client process. For example, the sqlplus service process is responsible for connecting to the client. Two modes: private

Solution to the problem where shutdown does not respond in oracle 11g: the database is inserted, then commit, and then shutdown. oracle does not respond. Solution: Because the database has a large amount of data to roll back, first execute SQL>

The statements you should know in ORACLE are frequently used. We should remember that, however, the human brain is not a computer, and we may regret them when we forget to use them, so we will record them one by one, there will also be traces for

Declare a stored procedure for returning a cursor 1. Declare a dynamic cursor type in the header. TYPE ref_cursor_name is ref cursor; 2. Define Dynamic CURSOR variables in the output parameters of the stored procedure to be declared. Create or

The usage of copy from in oracle Java code 1. syntax and usage instructions 1.1 syntax below let's look at the syntax and usage instructions of SQL * Copy Command. Before interpreting the syntax of SQL * Plus Copy Command, we must make it clear that

The Oracle analysis functions Lead () and Lag () are actually very well understood. Lead () is to take the next record of the current order, relative to Lag () is to take the last row of records in the current order. It is often necessary to

Failed to create multiple Oracle triggers consecutively. solution 1: When I create multiple triggers consecutively, the compilation is always successful, but there are warnings or errors. Create or replace trigger tr_advert before insert on

Common ORACLE errors and solutions are not as easy to remember as they are. In the future, we will record the common oracle errors in the project. 1. ORA-24324: Error Description: [SQL] SQL> shutdown immediate; ORA-24324: service handle not

Linux script command record (database) operation steps for DBA, often encounter Database Upgrade or apply patch, and sometimes need to run a large number of scripts. For these operations, we want to output files simultaneously on the screen for

Libg2c. so.0 is needed by compat-gcc-34-g77-3.4.6-4.i386 handle errors Oracle requires compat-gcc upon installation, I encountered the following problem during RHEL5.4: [root @ localhost rpm] # rpm-ivh compat-gcc-34-g77-3.4.6-4.i386.rpmwarning:

When e is used to create a tablespace, user, imp, exp, And conn [html]/*, it is divided into four steps * // * Step 4: create a temporary tablespace */create temporary tablespace user_temp tempfile 'e: \ oracle \ oradata \ user_temp.dbf 'size 50 m

The web OS commander External table web External table is read-only and can not be written as a conventional external table, while the OS commander web External table is a deformation body. For details, refer to several examples. Gtlions = # create

Plsql connection to oracle Method 1: PLSQL Developer installation 2: unzip instantclient 3: Set environment variables related to instantclient 4: Add sqlnet. the ora file content is # sqlnet. ora Network Configuration File: E: \ app \ limn \ product

Oracle 10g rac standby automatic log deletion script [plain] #! /Bin/bash export ORACLE_HOME =/opt/oracle/product/10.2.0/db_1 export ORACLE_SID = standby1 export ARCHIVE_DIR =/log/archivelog export LOG_FILE =/home/oracle/logs/del_archive.log if [! $1

The size of data files in Oracle limits the size of Oracle data files. The limit is that each data file can contain up to 2 ^ 22-1 data blocks. This limit directly results in the maximum allowed size of each data file. Under 2 K Block_size, the

Create or replace function getStrWxr (id in varchar2) RETURN varchar2 AS v_wxrname varchar2 (20 ); BEGIN/* SELECT csrname into v_wxrname FROM workorder_dispatch inner join csr on csr. csrid = workorder_dispatch.csr_id WHERE wo_id = id; */SELECT

Methods for oracle cross-database query this article briefly describes how to implement ORACLE cross-database query by creating a database link. configure tnsnames for the local database server. ora File $ vi $ ORACLE_HOME/network/admin/tnsnames.

[Oracle] Let's Talk About Lock and Latch. First, let's talk about what they have in common: they are essentially an exclusive Lock on resources, all caused by concurrency (if the database has only one session, ). Next, let's talk about their

Application cursor of the target in plsql: cursordeclare cursor c is -- declare a cursor select * from emp; v_emp c % rowtype; begin open c; -- open the cursor fetch c into v_emp; -- take out this record and save it to v_emp. After taking it out,

Use the variable in Oracle view 1. create a package (similar to the java Interface) Java code create or replace package p_view_param is function setStringOne (strOne varchar2) return varchar2; function getStringOne return varchar2; function compute (