Oracle

Basic concept of oracle: Database vs Instance is the most confusing term for oracle users, especially those with ms SQL server experience. The two concepts www.2cto.com are actually quite simple to understand. Let's take the notepad notebook as an

When IMP data is imported to the specified tablespace through imp, the data is imported to the tablespace corresponding to the dmp file generated by exp by default. For example, if you use orcl_dev user and exp data and orcl_test user imp data, the

Automatic Generation of document numbers based on format strings (ORACLE version) This code automatically generates document numbers for strings with specific keywords. Www.2cto.com @ SJ --- the format string (which is the keyword meaning below) "%

How to enable and Block Database Oracle archive mode Oracle training: Oracle archive mode the following articles mainly describe how to correctly start or block Oracle archive mode, we all know that Oracle databases run in two modes. Oracle archive

Oracle entry to master Part 3-query 1 Table query (1) introduction to basic oracle Table query www.2cto.com in our tutorial, we use several tables (emp, dept) Existing by scott) it demonstrates how to use the select statement. The select statement

[Oracle] Tree Structure Query [SQL] -- tree structure query in oracle is actually a sequential traversal-displays the tree with KING as the root node, start with defines the START Node SELECT * FROM emp a start WITH. empno = 7839 connect by prior.

Oracle service description 1. OracleCSService process: ocssd.exe cluster Synchronization Service (css)-manages cluster configurations. By controlling nodes, the member clusters and notification members are added to or removed from the cluster when a

In the oracle database, the insert and update operations on the data table cannot be performed in the oracle database, and the data table cannot execute the update statement because the data table is locked by other users. The solution is as follows:

Redo01.log, redo02.log, and redo03.log are online files, which are first stored in logs. After full storage, they are stored in redo02.log and then in redo03.log. After the storage is complete, they are stored in redo01.log cyclically (covering: the

In linux, the oracle netca Listener Configuration listener starts and stops: lsnrctl start -- start lsnrctl stop -- stop lsnrctl status -- view the status www.2cto.com netca Listener Configuration [oracle @ dev root] $ cd/u01/app/oracle/product/11.2.

Oracle calculates the cumulative cross-day time dimension TABLE from the beginning of the year to the current DATE: www.2cto.com SQL code CREATE TABLE D_TIME (D_DAY DATE NOT NULL, C_DAY_ID VARCHAR2 (8) NOT NULL, C_MONTH_ID VARCHAR2 (8) not null,

Today, I want to go into something meaningless: many people know that it is meaningless to use null values for comparison. But have you ever actually tried it?Try to see if there are some strange phenomena. Let's take a look at the following two

Solution: Oracle exception ORA-01861: literal does not match format string (string format mismatch) today, when writing a stored procedure, it always reports an error. For future reference. Error: Oracle exception ORA-01861: literal does not match

The Oracle keyword rownum uses Rownum, which is a pseudo column provided by oracle. We use a lot of data during paging. If rownum is improperly used, it will often be crazy. Assume that the table structure is as follows: www.2cto.com tid tname ttype5

Oracle obtains the table storage location and creates the tablespace C: \ Users \ Administrator> sqlplus SQL * Plus: Release 11.2.0.1.0 Production on Friday March 1 17:16:09 2013 Copyright (c) 1982,201 0, Oracle. all rights reserved. enter the User

Oracle commit detailed usage commit working process before commit is submitted Oracle generates a revocation record in the SGA undo segment buffer, the undo record contains the old value www.2cto.com for updating and deleting table rows. Oracle

Maybe you don't know about the ORACLE secret series-Oracle 11g introduces Case-sensitive passwords for database authentication. along with this if you wish to change the password (temporarily) and reset it back to old, you will find that password

Precautions for oracle Import and Export: The oracle Import and Export solution is the main melody of backup and reply, not dba. There is not much research on data import and export, and there is only a little bit of experience in the use process,

For the stored procedure of displaying the execution plan in the Oracle index access mode, see http://www.bkjia.com/database/201303/192688.html (1) unique index scan of index unique scan. A single match is performed for a unique index. In a unique

The process of restoring the Oracle file to an instance 1. applicable Conditions: www.2cto.com 1. data files with the original Instance (the best full oracle path), such as oracle cold Backup recovery after the system is reinstalled or on other