Oracle

The following code has been tested and can be run directly.A brief description of Oracle analysis functions, multidimensional functions, and Model functions, mainly for BI report statistics, not necessarily comprehensive, but a few instructions on

Some beginners often do not use the option when creating indexes in Oracle databases. In fact, sometimes you can use some options in a suitable situation to increase the index creation speed. For example, to import data in large batches, we often

  The content of this lecture mainly includes: 1. segment shrinkage and table space usage monitoring 2. Perform segment contraction and roll back the high-water line 3. Set session suspension due to space problems 4. Transfer tablespace I. segment

  SQL code -- Trigger -- 1. DML trigger DML statements (DELETE, INSERT, UPDATE) /* A dml SQL statement may have multiple or only one row. The statement trigger triggers each SQL statement. The trigger is executed only once. The Row-Level Trigger is

1. oracle optimizer======================================Oracle has three OptimizerRULECOSTCHOOSEThe OPTIMIZER_MODE parameter is used to set the optimizer type. It is a selective optimizer by default and is both a CHOOSESQL> show parameter OPTIMIZER_

  The permission system of the oracle database includes system permission and object permission. Database system privilege allows users to execute specific command sets. For example, the create table permission allows users to create tables, and the

How to create an oracle Function IndexAn important new feature of Oracle8i is the addition of the function-based index (hereinafter referred to as the FBI ).With this feature, Oracle DBA can use functions or expressions in the index. These functions

1. Patch preparation There are four main points:1) use Telnet to log on to the application server and check the Unix server type. Currently, there are three types of server (ibm aix, SUN Solaris, and hp ux.2) view the version number of the program

Manage common Oracle data dictionaries and dynamic performance views 1.v$ version query database version information [sql] select * from v$version; [html] BANNER --------------------------------------------------------------------------------

Oracle Basic Data Query SELECT * FROM MERs WHERE customer_id not in (2, 3, 4, NULL); SELECT * FROM customers WHERE customer_id BETWEEN 1 AND 4; SELECT * FROM customers WHERE customer_id not between 1 AND 4; -- NAN indicates that it is not a number

To quickly find the trc files generated by tracking other sessions, the most fundamental technology is to understand the path where the session tracking files are stored and the naming rules for generating the tracking files. Otherwise, in a

ORA-1157 and ORA-01110 error practices often encounter related ORA-1157OR1110 errors in the backup experiment, related error information, nothing more than data files, log files, and control files and a series of related file problems, in general,

[Oracle]-[TWO_TASK]-The Role Of The TWO_TASK environment variable is the two connection strings currently configured (one local database and one remote database ): [oracle@liu admin]$ more tnsnames.oraBISAL = (DESCRIPTION = (ADDRESS = (PROTOCOL =

Oracle transaction processing automatically submits data in three types: explicit commit, implicit commit, and automatic commit. The three types are described below. 1. explicit submission: Use the COMMIT command to directly complete the submission.

ORA-01438 Processing MethodSolution: (1) Track and execute the inserted SQL/stored procedure, locate the row that causes the culprit, and insert the row again after modification. (2) The simplest way is to increase the precision of the target field.

Oracle Database creation and date format usage Install oracle Instance name orcl, system password system/* Database creation steps:1. Install the oracle database tutorial, enter the Instance name orcl, and finish creating the instance database.2. in

This article to tell you about the solution of ORA-28002: Password 7 days after the expiration method, you can look at the students who need to refer to oh, good time not to say more let's see it. Symptom description:Log on to oracle 11gERROR: ORA-28

New users ask me about SQL statements or instances for creating users, roles, authorization, and tablespace in Oracle. Let's take a look at this article. Each oracle user has a name and password, and has tables, views, and Other Resources created by

Starting from 11 GB, oracle supports cross-platform table space transfer.View the list of supported platforms. If the endian format of the source and target databases is inconsistent, You need to convert SQL col platform_name Solaris

I. SQL tuning class 1: List several table Connection MethodsHash join/merge join/nest loop (cluster join)/index join 2: How to view SQL Execution plans without using third-party toolsSet autot onExplain plan set statement_id = & item_id for &