Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 10g relations with the constraint of column properties NULLABLE     - Linux centos rm directory does not prompt (Linux)

- About Java 7 module system (Programming)

- Ubuntu 14.04 build Hadoop 2.5.1 standalone and pseudo-distributed environment (32-bit) (Server)

- MySQL multi-instance configuration (Database)

- OpenWrt modify flash size (Linux)

- Get the Linux device PCI ID method (Linux)

- C language Bubble Sort - integer sort (Programming)

- Systemd on RHEL7 (Linux)

- Linux pwd command learning experience (Linux)

- Batch download files using the explorer under Windows Server 2008 R2 (Server)

- Dell R710 server disk recovery database one case (record) (Server)

- Oracle SDE and maintain common commands - Display space (Database)

- Use top to monitor the remote server (Server)

- APR for Tomcat installation under Linux (Server)

- Linux beginners should know 12 commands (Linux)

- Merge sort Java implementation (Programming)

- MySQL query performance comparison of a single truth (Database)

- SHELL script to use anti SSH brute force and vsftpd (Linux)

- How to contribute code on GitHub uploads (Linux)

- Construction CA certificate using OpenSSL command line (Server)

 
         
  Oracle 10g relations with the constraint of column properties NULLABLE
     
  Add Date : 2018-11-21      
         
         
         
  In conclusion:

columname type not null result check (columnname is not null) is not the same

therefore:

1, no need to manually to match NULLABLE property, when all explicitly bound by the result NULLABLE Y variable N is deleted, NULLABLE will naturally return to the Y.

2, try not to use to achieve CHECK NOT NULL, you can use the MODIFY statement or directly in the field after

drop table zwxtest04;
create table zwxtest04
(

 id integer
);
alter table zwxtest04 add constraint zwxtest04c2 check (id is not null);
select * from user_tab_columns where table_name = 'ZWXTEST04';
select * from user_constraints where table_name = 'ZWXTEST04';

--NULLABLE Is Y, constraint and does not lead to change NULLABLE

drop table zwxtest04;
create table zwxtest04
(

 id integer not null
);

select * from user_tab_columns where table_name = 'ZWXTEST04';
select * from user_constraints where table_name = 'ZWXTEST04';

- NULLABLE is N, and automatically add a C-type NOT NULL constraints

drop table zwxtest04;
create table zwxtest04
(

 id integer

);
alter table zwxtest04 id not nul;
select * from user_tab_columns where table_name = 'ZWXTEST04';
select * from user_constraints where table_name = 'ZWXTEST04';

- NULLABLE is N, and automatically add a C-type NOT NULL constraints

drop table zwxtest04;
create table zwxtest04
(

 id integer
);
alter table zwxtest04 add constraint zwxtest04c3 primary key (id);
select * from user_tab_columns where table_name = 'ZWXTEST04';
select * from user_constraints where table_name = 'ZWXTEST04';

- NULLABLE as N, P-type constraints create, create UNIQUE index

alter table zwxtest04 drop constraint zwxtest04c3;

--NULLABLE To Y
     
         
         
         
  More:      
 
- Java precision four operations (Programming)
- Making Linux root file system problems on-link library (Programming)
- Caffe install under Ubuntu 14.04 64bit (Linux)
- OpenGL ES 3.0 vertex buffer (Programming)
- Binary tree and some basic operations with binary list (Programming)
- How to configure Ceph stored on CentOS 7.0 (Server)
- Linux operating system to solve a serious fault handling (Linux)
- Android Dynamic efficiency articles: a brilliant Loading Analysis and Implementation (Programming)
- Switching Virtual Machine + Ubuntu graphical interface and terminal interface (Linux)
- The development environment to build Nodejs under Ubuntu 14.04 (Linux)
- Vim useful plugin: vundle (Linux)
- How to modify the Sublime in Tab four spaces (Linux)
- Python function arguments * args and ** kwargs usage (Programming)
- Java source implementation of the observer pattern instance (Programming)
- Linux kernel source tree to establish load module hello (Linux)
- RedHat Linux 6.4 install Oracle 10g error (Database)
- JavaScript prototype and the prototype chain (Programming)
- C # dynamic class notes --- (Dynamic) Applications (Programming)
- Linux server dual-card dual-IP and single-card dual-IP configuration method (ReHat / CentOS) (Server)
- Spring JDBC Comments (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.