Oracle

The protection level of Data Guard 10g is RESYNCHRONIZATION. After the data guard of Oracle is created, check the value of protection_mode and protection_level of v $ database. If the value of protection_mode is maximum availability, the value of

The RAC cache fusion mechanism is introduced in a single instance. to modify a data block, the process must be in the Current copy) the same is true for modifying the RAC environment on www.2cto.com. This involves a series of questions: how to

PL/SQL is similar to SQL Sever in importing excel data. It is used to find a function to import excel Data. follow the steps below. The following is a detailed process, hoping to help cainiao like me. Www.2cto.com 1. Prepare an excel worksheet.

ORACLE default account unlock Problem description: After Oracle10g is installed, use scott/tiger to test, the following error message will appear: oracle10g the account is locked oracle10g the password has expired www.2cto.com cause: scott of Oracle1

Custom sqlplus sqlprompt after logon creates a login under any directory. SQL example: www.2cto.com E: \ oracle-study input content: define _ editor = sublime_textset serveroutput on size 1000000 set trimspool onset long 5000 set linesize 100 set

PL/SQL PLS_INTEGER type provides some performance. If PLS_INTEGER is used, oracle uses the native machine algorithm. All other numeric data types are the same as the NUMBER data type. The result of using the C Language Algorithm Library is that the

In oracle decode, if the result of the decode function is an aggregate function, you must add the value or item of the decode judgment to the group by statement, for example, www.2cto.com select. C _ FUNDCODE, A.D _ REGISTERDATE, DECODE (. C _ FLAG,

In Oracle, SQL queries table information because the data structure design of some modules of the project is not strictly in accordance with a certain specification design, it can only beTo query the data structure, you need to query the following

Oracle Creates table partitions based on existing tables and data and imports data. Assume that the existing System. Test Table has over 10 million data records and is in the ts_Test tablespace. The table contains column A, which partitions data

An in-depth understanding of Oracle tables (1): ORDERED and USE_NL ORDERED are good at understanding, that is, they represent sequential join Based on the table following from, from left to right, the table on the left is the driving table use_nl (t1

When PowerDesigner generates an SQL script for database table creation, double quotation marks are used to generate an SQL script for database table creation. Especially for Oracle databases, table names are usually enclosed by quotation marks. In

Oracle Database notes --- basic usage of pl/SQL 2.pl/ SQL: Create a table:. enter your account and enter the password www.2cto.com B. select All objects in the drop-down box on the left. There are many tables, which are built-in tables. In the

If Oracle is not installed, PlSqlDeveloper re-installs the company's machine a few days ago. Basically, all the work needs are installed, so oracle is worse. Generally, plsql developer is used, it cannot be used without oracle installation, but it

A set of user-defined functions related to the ID card number 1. Verify that they are digits www.2cto.com [SQL] CREATE OR REPLACE FUNCTION IS_NUMBER (STRING VARCHAR2) return integer is begin if (LENGTH (TRIM (TRANSLATE (STRING, '+ -. 0123456789 ', ''

When Oracle is installed on Windows 7, the internal program is terminated abnormally. solution: the program is terminated abnormally. An internal error occurs. Please provide the following documents to the Oracle Technical Support Department:

Oracle dynamic performance view v $ event_name V $ EVENT_NAME view lists a set of waiting events. It provides information about sessions that must be processed:For official documents on www.2cto.com, see V $ EVENT_NAMEV $ EVENT_NAME displays

Oracle WHERE conditions and sorting 1. Condition Introduction The general form of conditions is the most common form of conditions: gyj @ OCM> Select * from t1 where name = 'gyj1 '; id name salary ---------- 2 gyj2 8000 conditions can only be

Oracle DBCA database encountered ORA-21561: OID generation failed error solution tonight when using DBCA database creation, enter the following interface, the machine on to go to the bath. Www.2cto.com results after the bath back, found that the

Unzip *. zip has encountered zookeeper before using 'checkdir error: cannot create database' Case Review: The oracle user created under root of www.2cto.com linux, and then use oracle to log on to the Command Used to decompress the oracle10g.zip

Oracle grouping function rollup, cubeRollup (Field 1, Field 2 ):Cube (Field 1, Field 2 ):Rollup (col1, col2 ,...) and cube (col1, col2 ,...) the usage difference lies in the cube in the record set summarized by rollup, and the summary of fields such