What is the difference between column level constraints and
table level constraints?
Answer Posted / pcsenthil
we can achive all type of constraint in both level but we
cannot use NOT NULL in table Level, the reason was "All
Constraint will give logical view to that particular column
but NOT NULL will assign to the structure of the table
itself.. that's why we can see NOT NULL constraint while
Describe the table, no other constraint will be seen.
Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
what are archived logs?
What is system global area (sga) in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Explain the use of consistent option in exp command.
In oracle there is column command, how will you explain that?
How do I know if oracle is installed on windows?
How to login to the server without an instance?
What are the uses of Database Trigger ?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Explain an extent?
How to bring a tablespace online?
how do u setup a replication site?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Explain the difference between a procedure and a function?