Oracle

--CREATE table space and database files and default tablespace sizeCreateTablespace tablespace_test datafile'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DataBase_Test.DBF'size 200m;--set up automatic database growthAlter DatabaseDataFile'E:\ORACLE\PRODUCT\

Reference: http://blog.csdn.net/oraclemch/article/details/5551634Oracle 11g Beginner's GuideHttp://www.cnblogs.com/netsql/articles/1745978.htmlOnline information are very fragmented, and most of them can not complete the requirements of the function,

Ok, that's looks hard, and if you use this procedure I wrote, its really quite easy, it does all of the work for you:Create or Replace procedure Html_email (p_to in Varchar2, P_from in Varchar2, P_subject In Varchar2, p_text in varchar2 default

Ott is an important tool for accessing object type data in the OCI, which maps object data types or collection types in a database to struct types in C + +. Ott is brought in by Oracle, but the environment variables must be configured before use.

Change Oracle from archive mode to non-archive modeStart –> Run command cmd into command line mode1. Use the command Sqlplus to open the following form without logging:Sqlplus/nolog;2. Connect to the database Dev.world where Dev is the Oracle SID is

1. Oracle memory is composed of SGA+PGA2. Oracle Database ArchitectureDatabase architecture refers to the composition, working process and principle of database, and the organization and management mechanism of data in database.How Oracle Works:1),

Each group of queries can get its result set, and if you want to combine multiple query results into a single result set, you can use the set operation to implement.such as the Union, set, and do not remove duplicate rows (unoin all), intersection

Beginners often confuse terminology such as Oracle instances, Oracle databases, and Oracle servers.Typically an Oracle database can be divided into two parts1. Example (instance)An instance is a non-fixed, memory-based, basic process and memory

1. Nvl functionNVL (EXPR1,EXPR2), returns EXPR2 if Expr1 is empty;2. NVL2 functionNVL2 (EXPR1,EXPR2,EXPR3), returns EXPR3 if Expr1 is empty, otherwise returns EXPR2;3. Nullif functionNullif (EXPR1,EXPR2), if EXPR1=EXPR2, returns NULL, otherwise

1. Create a data table space:SQL>Create tablespace rusky_data 2 'D:\rusky\rusky_ DATA01,DBF' size 10M 3on 4 Next 10M maxsize 1024m 5 extent management Local, table space created. EXTENT MANAGEMENT LOCAL: Storage area management method.

Transferred from: http://lorry1113.javaeye.com/blog/513851Keywords: Oracle stored procedures1. Basic structure CREATE OR REPLACE PROCEDURE stored procedure name (parameter 1 in number, parameter 2 in number) is variable 1 INTEGER: = 0; Variable 2

Create user MCC identified by manager; Note here that the password should not be extended with single quotes. Drop  user  mcc  cascade; Direct Delete user Create user MCC identified by manager D Efault tablespace mcc01 temporary

The LAG () and lead () statistics functions are able to fetch the first n rows of the same field and the values of the last n rows in a single query . Such operations can be implemented using table joins to the same table, but using lags and leads

A: PrefaceRecently decided to summarize the knowledge points every day, and then each week to publish the knowledge points in the classification of the journal.II: The Question(1): In Oracle for age calculation, know that the date of birth after the

Oracle Data Import Export IMP/EXPFunction: Oracle data import and export imp/exp is comparable with Oracle data restore and backup.In most cases, the data can be backed up and restored with Oracle data import and export (no loss of data).Oracle has

Check the information you need to focus on within two days:VI alter_error.shecho "Check Alter Error:" Cat $TRACE/alert_$oracle_sid.log | GREP-E ^ora-\| reconfig\|abort\| shut\|^start\|error\| instance\| suspend\| resuming\| Deadlock\| " ' Date '

Attention:After Oracle version 9.2, Oracle's maintenance release number is changed at the second digit bit. And before that is in the third digit digit.1. Major Database Release NumberThe first digit bit, which represents a new version of the

Oracleblockcorrupt Bad blocks In general, oracle's Bad blocks can be divided into two scenarios: physical damage and logical damage. The physical damage is caused by storage and other reasons. As a result, oracle finds that the checksum of the block

[Practice] Silent Installation-oracle11.2.0.3oncentos5.10 I found many Silent Installation articles on the Internet, which are messy and varied! Come to the literacy class! Install oracle 11g_r2 ************************************* in centos 5.10 **

11g new feature _ visible and invisible Index When you want to evaluate the impact of an index on your SQL query statement, when your database is 11 GB, you can quickly set the index to VISIBLE or INVISIBLE. In commendable cases, when the index is