Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 10g relations with the constraint of column properties NULLABLE     - Installation Experience open source car Automotive Grade Linux system (Linux)

- Linux unpack the tar file to a different directory (Linux)

- Vim configuration instructions (Linux)

- Build and verify MongoDB3.0.7 version (shard + replica) Cluster (Database)

- Python Flask environment to build (Linux)

- Linux automatically install service components and optimize the kernel parameters (Linux)

- Linux data redirection (Linux)

- Linux RAID Set RAID 10 or 0 + 1 (Linux)

- Linux Learning --- disk partition / relational representation + mount (Linux)

- Ubuntu 14.04 compile and install Apache (Server)

- The Linux-based security settings Ipchains Firewall (Linux)

- Python decorators to learn and practice the actual usage scenarios (Programming)

- ORA-30926 and MERGE tables empty the temporary occupation problem (Database)

- CentOS replaces update source and Linux kernel compilation summary (Linux)

- Ubuntu and Derivatives users install the latest KKEdit 0.0.31 (Linux)

- Linux System Getting Started Tutorial: Linux file permissions brief description (Linux)

- MySQL enabled SSD storage (Database)

- How to query the role of Linux services (Linux)

- Teach you self-built Linux firewall free (Linux)

- MySQL and MariaDB traditional master-slave cluster configuration (Database)

 
         
  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:      
 
- Use cmake to compile and install MySQL 5.5 (Database)
- Ubuntu users to install household financial management tools HomeBank 5.0.0 (Linux)
- How to forcibly change the Linux system password on a regular basis (Linux)
- Android WebView use layman (Programming)
- Linux system started to learn: how to view the Linux thread of a process (Linux)
- Depth understanding of the use of Spring Redis (Programming)
- Type Linux commands (Linux)
- MogileFS system installation configuration example (Server)
- Ubuntu Telnet service settings (Linux)
- MariaDB phpMyAdmin installation and configuration issues to resolve under CentOS7 (Database)
- State and Linux nf_conntrack TCP disconnect time (Programming)
- How Bluetooth turned off by default in Ubuntu 14.04 (Linux)
- Ubuntu mysql stop fail to solve the problem (Database)
- ORA-12547: TNS: lost contact error Solution (Database)
- CentOS Nginx achieve 3 virtual machine load balancing (Server)
- Debian 8.2.0 (Jessie) fast clean installation tutorial (Linux)
- CentOS 6.6 command-line automatic completion (Linux)
- Eight kinds of techniques to solve hard problems Linux (Linux)
- Mac OS X systems create Ubuntu USB boot disk for the Mac (Linux)
- CentOS 6.4 (64bit) install Python 2.7.5 (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.