Oracle

Apply the trigger to the unique value of the corresponding field when inserting the table   -- Create an incremental SequenceCreate sequence lzeam_sp_loop_eq_seq minvalue 1 increment by 1 start with 1 Test:Select lzeam_sp_loop_eq_seq.nextval from

In the process of running Oracle, for various reasons, some objects, such as stored procedures and functions, are as follows: SQL> select distinct object_type from all_objects; Object_type------------------ClusterConsumer groupContextEvaluation

I am not a very strong person, nor a person who has too many qualifications to comment on such news. In a word, this is a fact and has no right to speak. But even so, I still have to say that this message has disappointed me and is very sad ......

Document directory Environment:  Beginner notes environment: Vbox Virtual Machine oel6 oracle10.0.2 1. precautions for installing OEL. For Linux, you must install the development kit or check the kernel option. Otherwise, no kernel crashes.

I recently learned Oracle9i 9.2.0.1 again with Lei. Although I used to study every problem from the DBA's perspective, but after all, we will find that the entire Oracle system architecture is not what we can do. So this time, we have changed the

Basic Concepts The Oracle database is divided into logical regions called tablespaces-forming the logical structure of the Oracle database. I Oracle databases can have one or more tablespaces, while one tablespace corresponds to one or more physical

-- Main Waiting ViewSelect * from V $ session_wait;Select * from V $ session_event;Select * from V $ system_event;Select * from V $ waitstat where count> 0; -- Related viewSelect * from V $ session_wait Select * from V $ filestat Select * From

Recently, a large volume of data stored in the process is interrupted, resulting in a lock on a table. Now I want to modify the stored procedure, because the lock exists and remains waiting. In PL/SQL developer, set the session status to killed.

1. What is the Oracle character set? The Oracle character set is a collection of symbols for the interpretation of byte data. It can be divided into different sizes and have an inclusive relationship. Oracle supports the national language

Concept 1A cursor is a memory Workspace of SQL, which is defined by the system or user as a variable. The cursor is used to temporarily store data blocks extracted from the database. In some cases, you need to transfer the data from the table stored

Back up Oracle databases in Java Java thread, process, processbuilder June 20, 2010 This article describes an example of using Java to execute the external Oracle Export command to back up the database function. This example is used to modify and

Ant has no problem in executing system commands. In this actual system command, two problems are encountered: one is that the command for starting the service contains spaces, and the other is how to back up the database and add the date

I. Inner join) The connection condition of the where statement first concatenates all tables to be connected into a "big table". If there are other conditions in the middle, you can use the restrictions, after reducing the number of columns and

Common Oracle management SQL commands Database Version SQL> select * from V $ version;Banner----------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.1.0-ProductionPL/SQL release

During development, we often encounter the cursor Writing of dynamic table names, which happens in the work, as shown below:   DeclareStralltable varchar2 (100 );Type cur_typ is ref cursor;C cur_typ; C_id number (18 );C_code varchar2 (100 );BeginFor

Why check points must occur when the database switches logs? What is the significance of this checkpoint? Which of the following table space management methods are available. Differences between local indexes and global indexes and their

During work, I found that a data computing result was abnormal. I checked the original data and did not find any problems. I then compared it with the system computing result. I was shocked: It was a lot bigger, so, check the program and find the

How to Implement comma-separated column-to-row Conversion     1. The conversion method is as follows: Create or replace view v_con_project as select CP. "con_num", CP. "project_code", CP. "req_money", CP. "is_has_build_dept", CP.

Share a little bit of experience: Seq_bos_t_priv_function is a sequence, and colnum1 is the primary key.Insert into Table1 (colnum1, colnum2) values ('select seq_bos_t_priv_function.nextval from dual', '1 ');Insert into Table1 (colnum1, colnum2)

Oracle EBS front-end error, reported Ora-00942: Table or view does not exist error, but do not know which table or view is in the end, and can not immediately see the code, trace is useless. Later, I suddenly thought that I could use events to