why can't we assign not null constraint as table level
constraint
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
What is the implicit cursor in oracle?
What is a table index?
How to convert character types to numeric types?
Explain a segment?
Explain enable novalidate constraint.
How to convert numbers to characters in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
How many types of segments in Oracle?
How to connect to a local oracle 10g xe server?
What is the data type of dual table?
What is hash cluster in oracle?
What are the built-in functions used for sending Parameters to forms ?
What is procedure overloading in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
What is tns entry?