Oracle

Naming conventions Variable specification 1. Enter the parameter, the unification begins with the i_ prefix, and cannot omit the in 2. Out of the argument, the unification begins with the o_ prefix 3. Local variables, uniformly

First, IntroductionHave been confused about the Oracle database client, how to configure, a few days ago because of the need to use Oracle, and the need to connect two different databases, through the Internet and ask colleagues finally put the

Stream is an extended application of Oracle's Message Queuing (also known as Oracle Advanced Queue) technology. Oracle's Message Queuing addresses event management through a publish/subscribe approach. Stream replication is just a data sharing

--Create tablecreate table T_eb_sys_dn_sequence_config (sequence_id VARCHAR2 () default sys_guid () not NULL, SEQ Uence_name VARCHAR2 () not NULL, Sequence_desc VARCHAR2 ($), Sequence_len INTEGER default 4 NOT NULL, RE Set_type INTEGER default 2

ASM Installation of Oracle InstallationThe last time we talked about building an Oracle environment, let's look at the installation of ASM automated storage Management in Oracle and the creation of ASM disks today.ASM: Automated Storage Management

Resources:1. The most important reference article, basically is to do this!!! : Https://www.inf.unibz.it/dis/wiki/doku.php?id=students:minnerebner:oracle:addingsrid.2. Example reference:

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, '

Four states of tablespace: Online,offline,read Write and ready onlySql> select file#,status,enabled from V$datafile;file# STATUS ENABLED--------  ---------           -------------1 SYSTEM READ WRITE2 ONLINE READ WRITE3 ONLINE READ WRITE4 ONLINE READ

SQL statements that are paged and sorted in Oracle using RowNumPreviously, paging was used to use such SQL statements: select* from (selectt.*,rownum row_num from mytable t order byt.id) b whereb.row_num between 1 and10 It is found that because the

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

The following steps describe EBS R12.2 How to register a customized module, refer to the Oracle SupportCreating a customapplication in Oracle e-business Suite Release 12.2 (document ID 1577707.1)1 download patch 3636980 Span lang= "ZH-CN" style=

A DML lock, also called a data lock, is used to ensure that data is complete when multiuser data is manipulated. DML locks prevent conflicting DML and DDL operations from occurring at the same time.DML locks have row locks,tx and table locks (table

Dynamic SQL and oracle dynamic SQLDirectory 1. Pass values to dynamic statements (USING clause) 2. Retrieve values from dynamic statements (INTO clause) 3. Dynamic call stored 4. Pass the return value to the PL/SQL record type. The % rowtype

(Modified) oracle11g listens to the configuration of multiple hosts and uses pl/SQL to connect to and operate multiple databases. Many friends in the development project do not use a single database, but have a single host as the database server for

Troubleshooting of SQL plus logon failures caused by su switching in OracleProblem description:The oracle database in the production environment suddenly fails to log on, and the oracle database in the rlwrap production environment suddenly fails to

The ora-12514tns listener cannot identify the Service requested in the connection Descriptor Today, when you remotely connect to a linux server, this error occurs: tnsnames. ora and listener. ora file configuration is not wrong, but is not connected

Complete constraint 3 (learning notes): constraint learning notesPrimary foreign key constraint FK Foreign key (FK) CONSTRAINT fk _ foreign key name foreign key (column name) REFERENCES table 2 (column name) -- General table 2 primary KEY   Delete

Use cursor to convert the format of specified fields in the data table in Oracle (pinyin to numbers) Application Scenario: Convert [sannanyinv] to [3 male and 1 female] In the NNDP field of the data table TB_USER. Main Script: A cursor script +

User Creation (learning notes), User Creation learning notes Create a user: Syntax: Create user Username identified by password [default tablespace name] [temporary tablespace table name] [QUOTA number [K | M] unlimited on tablespace name QUOTA

Database usage-oracle bitmap Index Currently, a large number of indexes are mainly B * Tree indexes. The index structure stores the rowids of key values and key values, which correspond one to one. Bitmap indexes are mainly created for a large