Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Oracle 10g in the unique and index problems     - Ubuntu 12.04 configure NVIDIA CUDA 5.5 Record (Linux)

- top command causes the system load increases (Linux)

- C language files update in real time (Programming)

- CentOS / Linux install VNC Server (Linux)

- xCAT Installation Kit (Linux)

- Linux ps command (Linux)

- The YUM package management under Linux (Linux)

- A process of how to get the current traffic in GNU Linux (Linux)

- Install apr support for Tomcat on Linux (Server)

- Ubuntu 14.04 Boot Repair (Linux)

- MySQL query plan key_len know all (Database)

- Install Ubuntu text editor KKEdit 0.2.10 (Linux)

- DB2 commonly used scripting sort out (Database)

- Linux filtration empty file command summary (Linux)

- Squid proxy server configuration under Linux (Server)

- JavaScript function part (Programming)

- Linux fast set ip bond (Linux)

- High-performance JavaScript loaded and executed (Programming)

- MySQL multi-master-slave synchronization (Database)

- Docker knowledge base (Server)

  Oracle 10g in the unique and index problems
  Add Date : 2018-11-21      
  Oracle 10g in the unique problems and index
create table test
(X integer, y integer, z integer
alter table test add constraint primary key (x); - generating a constraint, and produce the same name index
create unique index index01 on test (x, y);
--create unique index index02 on test (x, y); - does not allow duplicate index, even when the index names are different
create unique index index03 on test (y, z);
create unique index index04 on test (z, y); --index04 are different from each other with the index03 index
alter table test add constraint cons01 unique (x, y, z); - generating a constraint, and automatically generate a file called cons01 of UNIQUE index
alter table test add constraint cons01 unique (x, y); - generating a constraint, but with repeated index01 (index generated automatically in no particular order), and therefore can not automatically generate an index
alter table test add constraint cons01 unique (y, x); - generating a constraint, but repeated index01, and therefore can not automatically generate an index
--create unique index cons01 on test (x, y); - can not be executed, because the index cons01 has been occupied cons01 constraint indexes created automatically
alter table test add constraint cons012 check (x> 100);
alter table test add constraint cons013 check (x> 100); the same content can --check
Extract all constraints (UCPR)
Extract the name is not in the table all the indexes constraint
- Recent Consolidation Using Linux security module (Linux)
- Introduction and use of the Raspberry Pi (Linux)
- Build Python3.4 + PyQt5.5.1 + Eric6.1.1 development platform under Mac OS X 10.11.1 (Server)
- MongoDB start under Linux (Database)
- STL source code analysis - iterator each container classification (Programming)
- Ubuntu 15.04 / 14.04 install Ubuntu After Install 2.6 (Linux)
- Vim useful plugin: vundle (Linux)
- Nginx version information hidden or modified (Server)
- 20 Linux commands interview questions and answers (Linux)
- Install Open vSwitch under CentOS 6.5 (Linux)
- Use Linux firewall camouflage defense hacked (Linux)
- Linux system file directory structure Introduction (Linux)
- Ubuntu 14.10 / 14.04 how to install Quick Start tool Mutate 2.2 (Linux)
- Create a DLL using MinGW and Attention (Programming)
- Use PDFBox processing PDF documents (Linux)
- Ceph tuning --Journal and tcmalloc (Server)
- Arduino UNO simulation development environment set up and run simulation (Linux)
- CentOS 5.x install Lua 5.2.3 error (LIBS = -lncurses) (Linux)
- Shell array: Define Shell array, the array length (Programming)
- Linux shell string interception and stitching (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.