Oracle

First select the procedures folder in the left folder and create a new stored procedure, as follows:Create or Replace procedure Uc_users_amount_pro (endDate in varchar2) is insmember number; Permember number; Insmembermon number; Permembermon

1. View the name and size of the table spaceSelect T.tablespace_name, round (SUM (bytes/(1024*1024)), 0) ts_sizeFrom Dba_tablespaces T, Dba_data_files Dwhere t.tablespace_name = D.tablespace_nameGroup BY T.tablespace_name;2. View the table space

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,

Today on the oracle11g with the EXP command to export when encountered a strange phenomenon, no data table exp is always not out, the query found this is a new feature of Oracle 11g, when the table has no data, do not allocate segment, to save space.

The EXP export tool compresses the data backup in the database into a binary system file. Can be migrated between different OSThe Imp Import tool imports binary system files formed by exp into the database.I. EXPORT TOOL EXPIt has three modes:A.

NULL is a unique data type in the database description of NULL in Oracle NULLAbsence of a value in a column of a row. Nulls indicate missing, unknown, or inapplicable data. When a column of a record is NULL, it indicates that the value

Environment: Oracle 10g for AIX systemsTSM5.4IBM with Library LIB3584Cause of the problem:After migrating the database, after redeploying the TSM BA client and turning on the DSMC schedule process in the operating system where the new database

First, using Dbms_sql to execute the queryUse Dbms_sql to execute SELECT statements in the order of open cursor-->parse-->define column-->execute-->fetch rows-->close cursor;1. Create a team table structure, as shown in:Proteamid: Primary Key ID,

When an in-progress DDL operation executes or references a schema object (note), the Data dcictionary (DDL) lock is used to secure the definition of the schema object, and only a single schema object is locked during the execution of the DDL

Oracle automatically acquires row and table locks for DML operations, and the type of operation determines the behavior of the lock, which summarizes the situation of the DML operation Lock: SQL Statement Row Locks Table

"Previous topic" column conversion 1--Introduction of Pivot and Unpivot function Implementation case1001 Lufei1001 Shanzhi1001 Namei1001 QiaobaThe implementation results are as follows:1001 Lufei,shanzhi,namei,qiaobaTypical row and column

ERP System Form query interface could not be opened, the reason:ERP db rollback space is insufficient, resulting in the system DB does not have enough space to support form query operation;Solution:1, check erpdb1 and ERPDB2 log information content:

"Honor" congratulations oneself won the honorary title of young expert of Oracle user group (first batch of China)New Year group recruitment: China Oracle Elite Alliance 170513055Group Introduction: This group is everyone's a technology to share the

Organize your own commands that are common in Oracle:ORACLE11G has not supported Isqlplus anymore. Built-in Oracle SQL developer1-----User Multiple Login error, Locked:ALTER USER username account UNLOCK;2-----Modify User password:alter user system

I. Oracle Foundation 1.1 DDL (data definition Language) Definition language Create DROP,DESC (note that this operation can only be performed in PL/SQL Developer command Windows and cannot be performed in the Windows window) table tablename1.2 DML

Classification of dynamic cursors:A strong type: With a return statement, you can only open query statements with the same query result as the Ruturn type.Two weak types: no Rerurn statements. Can be opened for any query statement.--Steps to use

system table Space: contains data dictionary informationSysaux tablespace: Stores metadata for various Oracle applications (such as AWR operational data)You cannot change the size of a table space after you create itArea Size Management:Automatic

Oracle Database creates and uses memory structures for various purposes. For example, memoryStores program code being run, data, was shared among users, and private data areas for eachConnected user.Both basic memory structures is associated with an

Oracle object-oriented and set-oriented, oracle object-oriented This is a summary of my recent learning experience. 1. oracle object-oriented We all know that SQL is set-oriented, but it is undeniable that there are many places in oracle that

ORACLE error 1658 When importing data to oracle, the following error is reported multiple times: IMP-00003: encountered ORACLE error 1659ORA-01659: unable to allocate MINEXTENTS greater than 1 (in tablespace ZSTA_DATA_TBS) IMP-00003: