Oracle

----Creating a stored procedure create or replace procedure Inserttest asCURSOR CS is SelectID, name, CLA, addr, phone, tel, x, Y, shape, Objectid fromHotel_bak T2;begin forCinchCS Loop BEGIN insert into hotel (ID, name, CLA, addr, phone, tel, x,

Busy a few days, and finally with the VC connected to the Oracle database (32-bit), although only connected to the local. There is a feeling of enlightened.In the beginning, all kinds of not even, I put the software about Oracle completely deleted.

Lock table processing and queryView the locked table of the Oracle database and remove the lock list process 1. View locked Tables SELECT dob.object_name table_name,Lo.locked_mode,LO.SESSION_ID,VSS.serial#,VSS.Action Action,Vss.osuser

One use rule: before begin, affirm: PRAGMA autonomous_transaction;Two-use understanding:Autonomous Transaction is an independent transaction, which is understood autonomous transactionThe key, though called by the main transaction. Let's use an

First, the user· System users Sys,systemSYS and system are highly privileged users, and SYS is higher than the system permissions. Use SYS to log in must use SYSDBA or Sysoper permissions, and use system to log in directly. SysmanSysman is used to

An error occurred during Oracle logon, causing the user to be unable to log on with the following error-------------------------------------------------------------------------ORA-00604: A recursive SQL Level 1 error occurredORA-01653 table sys.aud$

recently, because the unit has asked for a demand, to determine the user name provided does not have full-width characters, at least two characters. Looking for a long time, want to use regular expression to solve, but the test of time to find that

1, Transactional Concepts: Concepts: A transaction is a logical unit of work in a database, a transaction consists of one or more SQL statements that complete a set of related behaviors, ensuring that the operations of this set of SQL statements are

Select from V$pdbs;name Open_mode----------------------------------------pdb$seed read ONLYPDB1 read WRITEPDB2 read Writesql> shutdown

When programming with Oracle SQL, the syntax for SELECT into is often used, such as the following simple example:SET serveroutput ondeclare Var_score INTEGER; Var_name VARCHAR2 (): = ' Sheldon ';    BEGIN SELECT score to Var_score from STUDENT1

In the same table, the data is archived by placing the row in the inactive state. Database, you can compress optimizations for those inactive row. While archiving is implemented, applications can be restricted from accessing only those data in the

indexing, setting up, modifying, deleting2007-10-05 13:29 Source: User reviews 0 Views 2986IndexAn index is an object in a relational database that is used to hold each record, and the main purpose is to speed up the reading speed and integrity

This section focuses on Oracle's introductory video for "wind brother".I. An overview of the architecture1. Physical structure (file structure)Oracle has four types of files: control files, data files, log files, parameter filesThere are two types

1. Specify Oracle_sid$ Export ORACLE_SID=DB122. Specify environment variablessuch as Oracle_base, Oracle_home, PATH (to include $oracle_home/bin)3. Select the authentication method• Operating system validation• Password file validation4. Create

Inconsistent backup: Because the backup operation cannot be completed instantaneously, and the data files are written all the time, the SCN is changing, when the nth data file is backed up,The SCN for the n+1 data file may have been different from

How to optimize SQL computing (3) sequence operations, SQL Cross-row Reference Early SQL statements do not directly support cross-row references. It is extremely cumbersome to generate sequence numbers and then JOIN them. The SQL statement after the

Atitit. attilax Summary of common partition APIs1. api source and oracle and mysql 1.1. partition definition partition by range (uid) use the values less than operator to define 1.1.1. mysqlpartition by range (uid) (partition p0 values less than (100

Oracle Exception In LoopWhen oracle SQL is used for programming, the SELECT INTO syntax is often used. For example, the following simple example: SET SERVEROUTPUT ONDECLARE VAR_SCORE INTEGER; VAR_NAME VARCHAR2 (50 ): = 'sheldon '; begin select score

Routine collection and sorting oracle trunc function processing date format (very practical), oracletrunc This article will share with you the knowledge of oracle trunc function processing date formats, which is of great reference value. For more

Manual creation procedure for Oracle 10 Gb DatabaseManual creation procedure for Oracle database write initialization parameter file set operating system environment variable create instance connect database as Administrator Start instance create