Oracle

When multiple stored procedures in Oracle use public constants, we can create a dedicated package to manage all constants. The definition example is roughly as follows: Create or replace package global_constant is/* Numeric constants *//* Ratio

Dual is a virtual table used to form the select syntax rule. Oracle ensures that there will always be only one record in dual. We can use it to do a lot of things, as shown below: 1. view the current user. You can execute the following statement in

Use RMAN to back up... the command contains... crontab, which you should have. -- Archive is returned once every week ,? The archiving process automatically keeps running.-- Archive if it is full, right? What you need to do is to back up the data

Document directory Oracle learning Summary (2) Oracle learning Summary (2) The main content of this article includes: Implement Auto-incremental ID in Oracle and delete repeated records in the data tableI. Auto-incrementing Id 1. First create

Instr (source string, target string, start position, matching serial number) In Oracle/PLSQL, The instr function returns the position of the string to be truncated in the source string. It is retrieved only once, that is, from the start of the

This is an operation to export all objects under the user's ebmall to the ebmall. dmp file under the test directory. The recorded log file is ebmall. log. Expdp xxyy/xxyyp schemas = ebmall directory = test dumpfile = ebmall. dmp logfile = ebmall.

1. Create a test table Create Table g_test (ID number (12 ),C_date date ); 2. Create a stored procedure Create or replace procedure prc_g_test isBeginInsert into g_test values (seq_cam_action_id.nextval, sysdate );End prc_g_test; 3. Create a

Introduction:During the development process, there are often modules that need to prepare reports or data statistics. Here we will record the oralce functions that have used to prepare reports during the development process. Several principles for

Create Table wzw_sales(Acct_no number (5 ),Person varchar2 (30 ),Sales_amount number (8 ),Week_no number (2))Partition by range (week_no)Subpartition by list (acct_no)(Partition part9 values less than (9)Tablespace dw_cdr_dataPctfree 10Pctused

Create or replace procedure pro_check_data isV_objectid varchar2 (100 );V_objectid1 varchar2 (100 );V_objectid2 varchar2 (100 );V_objectname varchar2 (100 );V_relaobjectid varchar2 (100 );V_priobjectid varchar2 (100 );V_sql1 varchar2 (1024 );V_sql2

In Oracle databases, tables are the most basic content. It can be said that the quality of table design is directly relatedDatabasePerformance. Therefore, when designing a table, in addition to complying with its inherent database principles, you

Using system; using system. data; using system. collections. generic; using system. configuration; using system. data. oracleclient; using system. text; using system. io; // /// Oracle database operation class /// internal static class

I. Overview Two data providers accessing ORACLE: lmicrosoft. NET Framework data provider for OracleOracle. NET data providers are provided along with. NET Framework 1.1. If you are using. NET Framework 1.0, you will need to download. Net managed

Yan Bin (write to me)Original blog (http://blog.csdn.net/binbinxyz), reprint please indicate the source! Assume that a five-digit number is obtained from the database as the serial number of the business on the current day (unique on the current

Basically, the syntax used is as follows:A. Obtain the syntax for creating a single table and an indexSet heading off;Set echo off;Set pages 999;Set long 90000;Spool Dept. SQLSelect dbms_metadata.get_ddl ('table', 'dept', 'Scott ') from dual;Select

The content of this article includes: deleting and modifying tables, deleting and modifying fields, deleting and modifying primary keys, foreign keys, unique, non-empty, and default constraints.View All Your tables: Select * From user_tab_comments;

————————————————      Hello World           —————————————————————— create or replace procedure HelloWorld ASbegin insert into MYPROCEDURE(id,name,city,MANAGER)values(1,'ss','ss','ss');end HelloWorld; Stored procedures are generally divided into

Solve the problem that the OEM cannot be opened Emctl start dbconsole Set oracle_sia = xsgj Emctl start dbconsole Set oracle_hostname = localhost Emctl start dbconsole Change the Oracle-> product-> 11.1.0-db_1> gmx-PC_XSCJ name to

1. What are the partition tables (indexes )?A partition table is a kind of data storage mechanism. It stores the data of a table in different memory segments, these different storage partitions are partitions ). Why? One of the reasons is that when

Happy Life of the Old Wang family     Abstraction of Oracle's Structure System An avid photographer-happy family of Old Wang     The first chapter of each Oracle book generally introduces the structure and system of Oracle. When this chapter is