Oracle

2011-05-10 14:57:53Category: LinuxFirst, the memory structureSGA (System Global area): Shared by all service processes and background processes;The PGA (Program Global Area): is proprietary to each service process, background process, and each

Data dictionaryDefinition: An object used to describe a user object.Oracle Nature:Oracle is a table (system table) to maintain the table (user table) of the database system, where the system table is what we call the data can be dictionaryOracle

Oracle Flashback: Automatic disk-based backup and recovery that restores a table to a point in time or SCN.1. View the Flash back zoneSql> Show parameter db_recovery_file_dest; View the details of the Flash back zoneSql> select flashback_on from

Long: variable long string data, longest 2g,long with VARCHAR2 column, can store long text up to one long column in a tableLong RAW: variable Long binary data, up to 2GCLOB: Character large object CLOB used to store single-byte character dataNCLOB:

DescriptionOracle Database ServerOperating system: CentOSip:192.168.0.198Port: 1521Sid:orclOracle Database version: ORACLE11GR2Specific operation:1. root User Login ServerMkdir-p/backup/oracledata #新建Oracle数据库备份目录Chown-r

Oracle database language types generally fall into five major types1 DDL (data definition language) Definition languageCREATE TABLE: Creating tablesALTER TABLE: Modify tablesdrop TABLE: Delete tables (delete the table as a whole, the table structure

Chinese Medicine Department inquires the Discharge patient Information Report the following errorThen see the SQL for the interfaceThen run the code inside the Plsql,ErrorProcessing method:1. Determine the location of the errorNow determine where

1 Create or Replace functionMca_detail_material_val (P_material_codeVARCHAR2,--actual Parameters2P_material_nameVARCHAR2,3P_mca_noVARCHAR24 ) 5 RETURN varchar2 as6 7 --Item code/name

In general, the Oracle database language can be divided into the following 5 major categories:1.DML Data manipulation language (data mannipulation Language): Querying, manipulating datasheet rows SELECT: Retrieving database table or view

Because of certain requirements, the production environment needs to have both database server and client installed on the same machine because Plsql does not have 64-bit clients. Unable to read the 64-bit database Oci.dll file, so need a 32-bit

1 Nested Loops Join--we use the set Statistics_level=all to observe the execution plan of the following table join statement:--T2 table is accessed 100 times (drive Table access 1 times, drive Table Access 100 times)--This set Linesize 1000 has an

1.SQL is divided into 5 major categories:DDL: Data Definition languageDCL: Data Control LanguageDML: Data Manipulation languageDTL: Data Transaction languageDQL: Data Query Language2.DDL (data definition Language): Create,drop,alter,rename toThere

database table structure:Insert the SQL statement: InsertId="Insert"ParameterType="com. Structure "> INSERT intoSTRUCTURE (ID, structurename, parentid, Structuretype, description, DeptID, Propertycompanyid, Sort,

How Oracle 11g completely uninstallsMethod/Step 1:Disable Oracle Services: Enter Computer Management, in the service, find all services at the beginning of Oracle, right-click to select StopMethod/Step 2:In the Start menu, locate Oracle->universal

The following tests are based on the EMP table under the Scott userFirst Test with a while loop and insert 999 data into the EMP table1 Declare2I Emp.empno%Type:=1;3 begin4 whileI +5 Loop6 Insert intoEMP (empno,ename,sal)Values(

--Create a userCreate user xiaoyi identified by root;--Modify the user's passwordAlter user xiaoyi identified by root;--View the table space owned by the userSELECT * from Dba_users t where t.username= ' Xiaoyi ';--Create a table spaceCreate

1- save Excel file as (text file (Tab delimited) (*.txt))2- Open PL/SQL Create temp table jh_info, Open tool - text Importer3- Open the file location in the upper left corner, select the prepared txt file, and open it. 4- Switch to Oracle data,

Permissions:Create sessionCREATE tableUnlimited tablespaceConnectResourceDbaCases:#sqlplus/nologSql> Conn/as sysdba;Sql>create user username identified by passwordSql> Grant DBA to username;Sql> Conn Username/passwordSql> select * from

Set the script for automatic archiving and Archiving Root User Mkdir-p/home/temp Cd temp Mkdir bin log tmp Chown-R oracle: oinstall/home/temp/bin Chown-R oracle: oinstall/home/temp/log Chown-R oracle: oinstall/home/temp/tmp  

Small table hotspot disks with abnormal methods for conversion of large data volumes, abnormal hot spots   I encountered a strange problem. There are two tables, which are about 0.3 billion of the Data. Table A has the A1 field, table B has the B1