Oracle

Oracle exceptions are predefined and custom exceptions (personally felt). Predefined exceptions include anonymous exceptions and non-anonymous exceptions. (Anonymous exception: No name, like ORA-00371; Non-anonymous exception: name, like

An IF.. THEN IF condition THEN Statements 1; Statements 2; .... End IF; Two IF.. THEN ... ELSE IF condition THEN Statements 1; Statements 2; .... ELSE Statements 1; Statements 2; .... End IF; Three IF.. THEN.. elsif IF Condition1

Build table: CREATE TABLE User_info (ID INTEGER NOT NULL,UserName VARCHAR () NOT NULL,PassWord VARCHAR is not NULL,CreateDate Date NOT NULL,The Status INTEGER is not NULL,Constraint Pk_user_info primary KEY (ID)); CREATE TABLE User_info_temp (ID

CREATE OR REPLACE PROCEDURE p_rebuild_all_index (tablespace_name in VARCHAR2,-this is the table space name, and you can pass in NULL if you do not change the table spaceOnly_unusable in BOOLEAN)--is only an invalid index operationAsSQLT VARCHAR (200)

Oracle Partition Partition Detailed summary This article from the following aspects to collate the concept and operation of the partition table:         1. Table space and the concept of partitioned tables         2. Table partitioning specific

a large number of insert data below is inserted in the table tables 300,000 of data, if the first time to build the index is 57s, not indexed time is 58s, so and indexing and inserting data is not related. Insert into table Select 1, ' TMP ' | |

Introduction: This article provides a comprehensive overview of the relevant concepts of the Oracle execution plan, accessing data access methods, linking between tables, and more. and a summary and overview, easy to understand and memory! +++

When you first use Oracle database, we may find it more difficult, in general, the initial use of a database, we would like to know what the operation is, the author believes that may be the following questions. 1, how to enter the SQL

Reprint please indicate the source: tedeum.iteye.com Thanks to open source, the use of openlayers+geoserver GIS development is very simple, can be applied to the development of MIS system experience, I summarized here as three steps: 1. Data

Introduction to Oracle Databases First, introduce Oracle database systems are a set of software offerings at the core of distributed databases delivered by Oracle (Oracle), the most popular client/server (CLIENT/SERVER,C/S) or browser/server

Method One:First, create a computational function>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>> Create or Replace function count_rows (table_name in VARCHAR2, Owner in varchar2 default null) return number Authid

Oracle sequence detailing and creating a self-added primary key Oracle Sequence PRIMARY KeySequence: A database object provided by Oacle to produce a series of unique digits.L provide a unique numeric value automaticallyL Shared objectsL primarily

2007/6/1 Oracle DML Select for UPDATE syntax examplesIn most cases, the processing done in the extraction loop modifies the rows checked out by the cursor, and Pl/sql provides a syntax for doing so. This syntax includes two parts-the FOR UPDATE

-- INSTR (source string, the string to find, starting with the first few characters, to find the ordinal number of matches) if it is not found, return 0. A bit like the Get array subscript Select INSTR in Java (' Ni ... HA,.OWCAO,NIA,.M,

--create Sales TableCREATE TABLE Sales(trans_date date, cust_id INT, sales_amount number); --insert Sale rowsINSERT/*+ APPEND * *Into SALESSELECT TRUNC (Sysdate, ' year ') + MOD (rownum, 366) trans_date,MOD (RowNum, cust_id),ABS (Dbms_random.

Add a comment to a table Comment on table Mw_sys. object instance of the Mwt_om_obj1 is ' business type. '; To add a comment to a column in a table Comment on column Mw_sys. Mwt_om_obj1. Unique identifier of the obj_id is ' object. ';Comment on

Symptom: Undo table space is getting bigger and longer this end data crashes because of insufficient disk space;Problem Analysis: The causes of the problem are mainly the following two points:1. There is a large volume of transactions so that Oracle

Ext: http://www.cnblogs.com/hustsay23/archive/2011/11/05/2237748.html The biggest difference between an Oracle database and SQL Server is that the latter is simple to accomplish. The graphical interface can be done step-by-step, and Oracle needs

Both date and timestamp are available for addition and subtraction operations.You can manipulate different time types for the current date Gagnin, month, day, hour, minute, and second, with three ways: 1 using built-in functions numtodsinterval add

1, Login server 2. See if the disk space is big enough df-h -H more Current disk space and usage to be displayed in a more readable way [Root@rac1 ~]# Df-h FileSystem Size Used Avail use% mounted on /DEV/SDA1 2.9G 2.3G 521M 82%/ None 209M 0 209M 0%/