Interested to Buy Any Domain ? << Click Here >> for more details...
why can't we assign not null constraint as table level
constraint
- 3 Answers
- 14234 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 |
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
What is a subquery?
how many types of index?
How many anonymous blocks can be defined?
which sql command we can use to get a print out from oracle?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
What is coalesce function?
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
How to write text literals in oracle?
How to start your 10g xe server from command line?
Oracle General 
