oracle complete reference

This is Oracle's description of the backreference of regular expressions As you can see from the definition, a substring is included in the form of a matching expression, which can be referenced later in the form of \. \1 corresponds to the first (), \2 corresponds to the second ... The introduction of reverse reference makes the matching function of regular expression become more powerful, and introduces two applications in

Tags: a source file PL/SQL Modify step Database configuration file Sqlplus fileOracle Auto-Disconnect database connection workaround method One, the direct modification of the resource configuration file is done in three steps in the Sqlplus environment. The first step is to query the resource file and find the profile name where Connect_time is located. Select Resource_name,profile from Dba_profiles; The second step is to modify the value in the profile with the ALTER command; ALTER profile mon

This document records how to create a table of Oracle structures in PowerDesigner. Before reading this article, you need to make DBMS modifications in PowerDesigner, database creation, user creation, and table space creation. 1. Create a table, fill in the Name,code,comment,owner (need to create in advance) 2. Create the corresponding columns in the table 2.1 Edit the primary key, select the primary key, click the Properties button (first button)