Interested to Buy Any Domain ? << Click Here >> for more details...
why can't we assign not null constraint as table level
constraint
- 3 Answers
- 14243 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lokanath
Because its a Column Level constraint.
Not Null is a Constraint which will ensure the Column
should not be null.
| Is This Answer Correct ? | 10 Yes | 12 No |
Answer / senthil
not null constraint applied on table level constraint but table must be empty otherwise not possible .
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / 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 |
Why packages are used in oracle?
What is Index and different types of Indexes?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
write a query that displays every Friday in a year with date?
What is the difference between "as" and "is" in an oracle stored procedure?
What is user managed backup in Oracle?
What privilege is needed for a user to query tables in another schema?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is transport network substrate (tns) in oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Oracle General 
