Oracle

1. Install \oracle\10201_database_win32.zip;A) installation diagram: http://jingyan.baidu.com/article/5d6edee228308899eadeec3f.htmlb) Note: the compatibility settings for the setup.exe run file are as follows:2. Install the Plsqldev8.0.zip tool.a)

oracle regular expression function-regexp_substr use example.5 parametersThe first one is the string enteredThe second one is the regular expressionThe third is to identify a regular expression match starting from the first few characters. (Default

The For statement is a loop control statement that can preset the number of cycles, which is a loop counter, usually an shaping variable that controls the number of times the loop is executed by this loop counterThe syntax is as follows:For variable_

Remote Service sideOperating system: Windows Server 2003 Enterprise Edition SP2Oracle version: Oracle 9.2.0.1.0 official editionLocal clientOperating system: Windows Server 2003 Enterprise Edition SP2Oracle version: Oracle 9.2.0.1.0 full version

I. Giving users permission to create and delete sequenceGrant create any sequence to user_name;Grant drop any sequnce to user_name;Second, view job settingsShow parameter JobIf job_queue_processes=0, then update the value to 1alter system set

First, viewSelectA.tablespace_name,a.bytes/1024x768/1024x768"sumMB ", (A.bytes-B.bytes)/1024x768/1024x768"Used MB", b.bytes/1024x768/1024x768"Free MB",round(((A.bytes-B.bytes)/A.bytes)* -,2) "Used%" from(SelectTablespace_name,sum(bytes) bytes

1, if order by ColumnA, then add the conditional columna=value in the where query condition, then Oracle will filter order by ordering, directly with the index.2, if order by COLUMNA,COLUMNB, then add the conditional columna=value1,columnb=value1 in

Select Max (field 1), Over (partition by field 2, Field 3) from table;--Remove the largest of field 3 from Field 2 and field 1 partitionsEquivalentSelect Max (field 1) from the table group By Field 2, Field 3;However, the above SQL will list all the

A few things to note about Oracle 11.2 Instance access ASM:1. The Oracle user and grid user must have the same group, and the ASM Disk's group is consistent with this group, otherwise the database cannot access ASM disks,Error Ora 15081For example:

1) SELECT * from T1 where exists (SELECT * from T2 where t1.a=t2.a);When the T1 data volume is small and the T2 data is very large, the query efficiency of T12) SELECT * from T1 where t1.a in (select t2.a from T2);T1 data volume is very large and T2

This is an Oracle's column change function: Listagg ()Look at the sample code first:SQL code With temp as ( Select ' China ' nation,' Guangzhou ' to dual Union All Select ' China ' nation,' Shanghai ' to dual Union All /c9>

1. View information for all objects under a user:SELECT owner, object_type, status, COUNT (*where owner='xxx' 2View Code2. View the number of table rows (multiple tables) (the table must be analyzed first):1 Select 'Analyze Table'|| table_name|

--Create a tableCREATE TABLEknet_domain_dns_forwarded (IDVARCHAR2( $BYTE)DEFAULTSys_guid () not NULL, KEYWORDVARCHAR2( theBYTE) not NULL, CNAMEVARCHAR2( +BYTE), URLVARCHAR2( +BYTE) not NULL, Create_date DATEDEFAULTSysdate not NULL, Update_date DATE,

The development of the project needs to use a query for the first day of the week Date function search n long hard to find a solution as long as you write a first with the code as follows A_week format for ' yyyyiw ' as ' 200801 ' for the first week

Path of the trace file under the ADR Management in 11g A 11G development library, intends to open the trace of sqlplus, check the connection information of sqlplus login, but configure sqlnet. ora did not find the trace file, and one day it was

Introduction to AWR AWR stands for Automatic Workload Repository ). It collects statistics by comparing two snapshots to generate reports in the form of txt or html pages. Generally, the AWR report can be used to understand the system pressure

RHEL5.8 reports a version error when installing Oracle10 RHEL5.8 reports a version error when installing Oracle10. If it is not supported, modify oraparam. ini # RUN_OUICA specifies the batch script name that needs to be run # The script is ouica.

Simple Oracle REGEXP_INSTR function usage The REGEXP_INSTR function allows you to search for a regular expression pattern string. The function uses the characters defined in the input character set for string calculation. It returns an integer

SQL join and SQL JOIN The join keywords in SQL statements are commonly used and not easy to understand. The following example provides a simple explanation-creating tables table1 and table2:Create table table1 (id int, name varchar (10 ))Create

Oracle Data Pump example, oracle pump example Main export example: 1. Export the specified tablespace: Expdp system/xxx DIRECTORY = dump_dir tableapace = xxx dumpfile = xxx _ % DATE :~ 0, 4% % DATE :~ 5, 2% % DATE :~ 8, 2% ". dmp logfile = xxx.