Interested to Buy Any Domain ? << Click Here >> for more details...
why can't we assign not null constraint as table level
constraint
- 3 Answers
- 14071 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 |
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
What is difference between SUBSTR and INSTR?
Explain user account with reference to oracle.
What is meant by an index?
How view is different from a table?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
How to update a table row with a record?
How to convert raw data type into text in oracle? Explain
What is set verify off in oracle?
What is a procedure in oracle?
can u plz provide me oca sql dumps please i need them
Oracle General 
