Interested to Buy Any Domain ? << Click Here >> for more details...
why can't we assign not null constraint as table level
constraint
- 3 Answers
- 14356 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / newton_dba
A NOT NULL CONSTRAINT IS USAUALLY APPLIED ON COLUMN LEVEL
BUT IT CAN BE APPLIED ON THE TABLE LEVEL BY USING ALTER
TABLE STATMENT
ALTER TABLE EMP
MODIFY (ENAME CONSTRAINT EMP_ENAME_NN NOT NULL);
| Is This Answer Correct ? | 7 Yes | 13 No |
Post New Answer View All Answers
How to load a large xml file?
What are privileges and grants?
Explain an index segment?
When system tablespace is created?
Where is the export dump file located?
Is java required for oracle client?
What are the uses of a database trigger?
What is the usage of synonyms?
what is the difference between substr and instr function in oracle?
How remove data files before opening a database?
What is parameterized cursor in oracle?
Can we create database in oracle using command line ?
What to do if the startbd.bat failed to start the xe instance?
How to assign values to variables?
How to create a single index for multiple columns?
