why can't we assign not null constraint as table level
constraint
- 3 Answers
- 12649 Views
- CTS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain what are the uses of rollback segment?
What is define in oracle?
what are the default admin accounts in Oracle 10g ?
Why do you create or replace procedures rather that drop and recreate.
defination of bitmap index
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is program global area (pga) in oracle?
Which is better Oracle or MS SQL? Why?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is a partition in oracle?
what is the difference between substr and instr function in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is oracle update statement with inner join ?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
