Oracle

The process of 1.sql parsing Oracle first converts the SQL text to ASCII characters and calculates its corresponding hash value (Hash_value) based on the hash function. The corresponding bucket is found in the library cache based on the

Check a table today, the query table in a particular type of data is particularly slow, but query the whole table particularly fast, also did not find the reason, Baidu a bit, may feel (a small probability) is the followingSome people say:Note that

CREATE OR REPLACE FUNCTION f_get_py_cap (p_name in VARCHAR2) RETURN VARCHAR2 asV_word VARCHAR2 (10);V_compare VARCHAR2 (100);V_return VARCHAR2 (4000);FUNCTION F_nlssort (P_word in VARCHAR2) RETURN VARCHAR2 asBEGINRETURN nlssort (P_word, '

This note will describe the nature and interrelationships of the logical storage structure in the Oracle database server in the segments, regions, and blocks.1. Introduction of data segments, sections and segments2. Overview of paragraphs3. District

1.1. Instant Client DownloadWebsite:Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.htmlDownload Instantclient-basic Package and store the package locally, this test is D:\JavaEEServer\instantclient_10_21.2.

The data pump tool can be called from the command good use program EXPDP and IMPDPFeatures of data pump technologyAll import/export work is done by the DB instancecan be established using dbms_datapump PL/SQL APL. Detecting and invoking data pump

This technique uses the same name as the operating system user to create the Oracle user, but preceded by the string specified by the Os_authent_prefix parameter, which defaults to ops$, let's take a look at the official document's description of

In Oracle, sequence is the so-called serial number, each time it takes its own initiative to add, usually in order to be ordered by serial number place.1. Create SequenceYou first have to have create sequence or create any sequence

First, download the official Oracle website, you can download the latest version of Oracle Database 11g release2http://www.oracle.com/index.htmlCentOS5.5I386 32-bit---Linux x86========================find a way to transfer the following 2 files into

1.OverviewOracle "CONNECT by" is a hierarchical query clause that is typically used for queries in tree or hierarchical result sets2. How to use 2.1. Via Connect byGenerating SequencesOracle constructs the number of days in a monthSelectTo_date ('200

Syntax for adding a field: ALTER TABLE tablename Add (column datatype [default value][null/not null],....);Modify the syntax of the field: ALTER TABLE tablename modify (column datatype [default value][null/not null],....);Syntax for deleting a field:

An example of OracleAny subquery Problem:Query the names, jobs, and salaries of employees with lower salaries than any salesperson ("SALESMAN") in the Emp table.Analysis:The salesperson has many records in the Emp table. The salaries of each person

10gR2Clusterware Installation Steps1. Install the Operating System (omitted)Note: I use the OEL 5u5 version here. Because it comes with the environment variable installation package provided by Oracle, It is very convenient to install the Oracle

Restoration Method for 10gClusterwareVotedisk corruptionVotedisk is very important for RAC (10g Clusterware, 11g GI). We call it an arbitration disk, when a node in the RAC cluster fails and the network is disconnected, it determines whether to kick

Oracle single row subquery Subqueries can contain SELECT statements in SELECT, UPDATE, and DELETE statements. The internal SELECT statement result can be part of the Condition Clause in an external statement,It can also be used as a temporary table

Ora-00054: resourcebusyandacquirewithnowaitspecified Solution When a database user inserts, updates, or deletes data from a table in a database, or adds a table's primary key, or the table's index, a ora-00054 often occurs: resource busy and acquire

Table Partitioning (learning notes), Table Partitioning learning notes Table partition: Application Scenario: For tables with a large data volume, for example, tables with 2 GB of data, 20 pieces can be queried, which is certainly faster than

Oracle12c cannot access http: // localhost: 1158/em. The em of oracle12c is simplified and much smaller than 11g, and the login method has also changed. The original http: // localhost: 1158/em or https: // localhost: 1158/em login will always

PLSQL _ Statistics Series 3 _ statistics are migrated in different databases (case studies), and plsql statistics 2014-01-05 Created By BaoXinjian I. Summary Because the system is upgrading or cloning data for migration, it may cause data

Numeric function (learning notes), numeric function learning notes -- ************************************ Digital functions-- ABS: returns the absolute value. SELECT ABS(3),ABS(-100) FROM dual; Result: 3,100-- CEIL rounded up SELECT