Oracle

The system environment is Microsoft Windows 98, Chinese Oracle 8i stand-alone version, the application is the health insurance system drugstore end, daily turnover of about thousands of yuan. Users reflect that the computer started when the computer

1. Hierarchical Query Semantic Analysis:2. Hierarchical Query Script test:---Delete a table that already existsdrop table test;--Create tableCREATE TABLE TEST(Orgno Number (TEN) is not NULL,Deptno Number (10),DEPTNM VARCHAR2 (20));---insert

before closing the backup control file/parameter file: Sqlplus/as Sysdbaalter Database backup controlfile to '/home/oracle/control.ctl.bak '; Create pfile= '/home/oracle/init& lt; instance name >.ora ' from SPFile;One, Oracle 11g RAC shutdown

Reprinted: 2015-01-17 15:32:33Http://www.cnblogs.com/FeiyueHang/archive/2011/03/08/1977729.html1.NVL (EXPR1,EXPR2)If EXPR1 is null, the function displays the value of EXPR2;2.NVL2 (EXPR1,EXPR2,EXPR3)If the value of EXPR1 is null, the function

Problem: The ID of the Customer table in the database changes to 21\31\41 ordinal number, not 1\2\3 growth in turn[Cause of problem]:Seq_customnoteen set the cache 20, take 20 numbers at a time, then one to you, if there is a period of time in the

Oracle BIEE can pass parameters through the narrative view to achieve the effect of controlling embedded page content with hints.① first, build a request condition (Answer) that requires passing parameters.② Select narrative View and insert the

constraint type Constraint_type in table all_constraints:C (check constraint on a table)--constraints, such as not Null,checkP (primary key)--primary keyU (unique key)-Unique key constraintR (referential integrity)--foreign key--The following two

When we upgraded our products from SPC100 to SPC200, we needed to write SQL scripts to complete the database upgrade because the data types of the database table columns changed. The primary key column ID for table t_mobile_indvconfig needs to be

What is a stored procedure?A stored procedure (Procedure) is a set of SQL statements that are compiled to complete a particular function, stored in a database, and executed by specifying the name of the stored procedure and giving parameters.Stored

Select Upper (' Testmyname ') from dual; --Convert to uppercaseSelect lower (' Testmyname ') from dual; --Convert to lowercaseSelect Upper (substr (' Testmyname '), 5) from dual; --intercept myname and convert to uppercaseSelec InStr (' Testmyname ',

The overall structure is divided into three parts: Sga,pga,file fileby function:Storage structureStorage structure Correspondence RelationshipMain documents:Data files: Each data file is associated with only one database A table space

First, TriggerA trigger is a block of code that executes automatically when a particular event occurs. For example, a record is added to the log table each time an action is made to add or delete an employee table. triggers and stored procedures are

First open the Control Panel-Administrative Tools-Data source (ODBC), add a data source driver for Oracle's user DNS, and fill in data source, Server Name, user, test for connectivity.Then, open the Access database, select the table that you want to

Principles and usage of cursor in oracle Introduction to cursor: Process query results row by row and access data programmatically Cursor type: 1. Implicit cursor: an implicit cursor is automatically created when a dml SQL statement is executed

Record an Oracle10g data recovery event Facts have proved that I will not die if I don't die. This Oracle crash took me two days, just because I installed some inexplicable Android simulators and uninstalled them again. After uninstalling the

Oracle Advanced Query 1. eliminate duplicate rowsIf several rows are the same in the Oracle query results, you can use DISTINCT to remove duplicate rows. Code Demonstration: Remove duplicate rows in DISTINCT SQL> SELECT DISTINCT DEPTNO FROM EMP;

Oracle performance optimization operation 15: functional-based index requirements equality matching We have created a function-based index, but if you execute the following query: select * from emp where substr (ename, 1, 1) = 's'; The expected

Guide for installing OracleXE on CentOS Introduction: Installing oracle xe on Centos is mainly used for learning and testing. Although simple, it involves many steps and details. 1. Download Oracle XE Access the

OracleDML Error Log DML error log is an error log function introduced by oracle10gR2 similar to SQL * Loader. The basic principle is to transfer any records that may cause statement failure to an error log table. The specific usage is as follows: 1.

Oracle performance optimization operation 18: whether to use full table scan or index Like all tips, the last trick will go back to the starting point. Finally, let's discuss whether to create an index, maybe it is faster to perform a full table