Oracle

When the M role is input on the page, because the value "m role" Oracle will understand that there is a format in the content, that is, Oracle's responsibility can only store the content, the format is not the responsibility of the database,

I have been providing technical support for 2 months. That is to say, I haven't touched the Technical Support for 2 months.CodeNow, I am very familiar with it. Recently, I encountered a big concurrency problem in the project, and the data was

Some time ago, in the company's big meeting room, I saw my colleague D reading the book "efficient Oracle design" and encouraged d to say, "Do you know? After learning this book, H colleagues of the company made a big breakthrough in Oracle

---- 1. having clause usage ---- having clause controls the row groups determined by the group by clause. The having clause conditions only allow constants, clustering functions, or columns in the group by clause.- --- 2. external join "+" usage --

The Oracle database system configures its own startup according to the parameters set in the init. ora file of the initialization parameter file. Each instance first reads the different parameters set in these parameter files before it starts.

# Listener. ora network configuration file: e: \ oracle \ product \ 10.1.0 \ db_1 \ Network \ admin \ listener. ora# Generated by Oracle configuration tools. Sid_list_listener =(Sid_list =(Sid_desc =(Sid_name = plsextproc)(ORACLE_HOME = E: \ oracle \

  1 Definition Audit_sys_operations audits sysdba activities. The default value is false. The related audit information is not recorded in AUD $, because it is possible that the database has not been started yet and can only be recorded in files at

This article mainly describes the data of the number type and how to store it in the database. Composition of the 1 Number Type The number type of Oracle consists of up to three parts, which are "highest bit", "Data Part", and "symbol bit ". The

To add sub-partitions for an existing partition (such as clah_201110), we can only add them one by one. It is very troublesome. The following code. I wonder if you have any good solutions. Of course, you can add partitions and subpartitions together

Operating System: Windows 32-bit Currently, Oracle does not provide 10 Gbit/s for download. It is useless to download a bunch of data. The latest 11g is usually 2g, nnd. Although 11G has been out for a year or two, many engineering and learning

Oracle instance startup1 Su-Oracle: Log On As an oracle user with the Oracle environment. Note-2 sqlplus sys/As sysdba, Log On As DBA3 startup [force] [restrict] [pfile = filename] [open [recover] [database] | Mount | nomount] Oracle startup

Ii. PL/SQL developer Installation 1. Download and install Http://allroundautomations.swmirror.com/plsqldev802.exe The registration code is self-searched, and many of them have registration machines. Note: Do not install it in the default c: \

The following is my own installation script for installing Oracle10g. It has been run in various centos5 versions.ProblematicThe usage is as follows:1. Test the following script in a file and run it under the root user.2. A running prompt is

Tree Structure and Its dedicated function sys_connect_by_path are simple tree structures. Common applications of trees After learning this function, I used the orgindustries table for a test: Normal Tree Structure Select lpad ('', 6 * (level-1) |

Oracle is different from MySql in many concepts. to switch from MySQL, you need to understand some Oracle concepts.1 Database and instance databases and Instances A database is a collection of physical files., Stored on a hard disk device, which

ORACLE: SQL plus has the ability to automatically submit jobs without requiring you to explicitly tell it what to do. It can be achieved through set autocommit on. Off is the default value, which is recommended in almost all programs. Before

On: http://mofeichen.iteye.com/blog/839111 C: \ Documents ents and Settings \ Administrator> sqlplus/nolog SQL * Plus: Release 10.1.0.2.0-production on Saturday December 26 11:08:34 2010 Copyright (c) 1982,200 4, Oracle. All rights reserved. SQL>

Configuration when a listener error occurs: |-Error 1: Oracle Database listening services often encounter errors. The Registry is deleted when the optimization software is used. Registration items of the listener service: HKEY_LOCAL_MACHINE \ SYSTEM

Some colleagues often ask questions about character sets in Oracle databases, such as data migration in different databases and data exchange with other systems, migration failure or garbled data in the database is often caused by different

From: http://blog.csdn.net/inthirties/archive/2009/08/03/4400905.aspx   A friend on csdn asks for a code segment for help. The code snippet is as follows: DeclareType t_indexby is table of numberIndex by binary_integer;Type t_nesteed is table of