Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 10g relations with the constraint of column properties NULLABLE     - 5 tips to improve your Linux desktop security (Linux)

- Linux Programming memory mapping (Programming)

- CentOS6.5 installation Docker (Linux)

- W and uptime command (Linux)

- Computer black magic: tail recursion (Programming)

- Chrome plug-in management, online-offline installation, part of the plug presentations (Linux)

- The YUM package management under Linux (Linux)

- Oracle database NUMBER (x, y) data types (Database)

- Linux SU command security Suggestions (Linux)

- VirtualBox installation enhancements let the mouse move and share CentOS 6.4 (Linux)

- File sharing and fork function (Programming)

- Linux system security Comments (Linux)

- open V switch port mirror in OpenStack neutron (Server)

- The Samba service does not have permission to access (Server)

- QEMU code analysis: BIOS loading process (Linux)

- After installing minimize RHEL / CentOS 7 we need to do (Linux)

- CentOS 6.5 system installation Oracle11.2.0.4 basic steps (Database)

- Android Studio and Git Git configuration file status (Linux)

- Installation and configuration of Hadoop under Linux (Server)

- 64 Ubuntu 15.04 Linux kernel upgrade to Linux 4.1.0 (Linux)

 
         
  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:      
 
- Linux account related documents Interpretation (Linux)
- shell script error dirname: invalid option - b (Database)
- Android realize RippleEffect water (Programming)
- Using VMware vSphere Client Linux virtual machine installation CentOS6.4 system (Linux)
- Installation and configuration under Linux SVN server - Backup - Recovery - Scheduled Tasks (Server)
- Setting Hibernate connection MySQL database connection pool coding (Database)
- E: Sub-process / usr / bin / dpkg returned an error code (1) error solution (Linux)
- Ubuntu install Vendetta Online 14.04 (Linux)
- MySQL master-slave database configuration and error handling Raiders (Database)
- Java inheritance initialization problem (Programming)
- Windows Server 2012 R2 Datacenter install SQL Server 2016 CTP (Database)
- iOS development -Launch Image and Launchscreen (Programming)
- Bash environment is automatically install and initialize oh-my-zsh & autojump zsh (Linux)
- Python in yield (Programming)
- Linux System Getting Started Learning: In RedHat Linux driver compiled Ixgbe (Linux)
- Linux add a new hard disk (Linux)
- How to become a better Node.js developers in 2016 (Programming)
- Android studio multi-channel ultra-compact version of the package (Programming)
- RAID disk array Description (Linux)
- CentOS7 install and configure Nagios (Server)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.