What is the difference between column level constraints and
table level constraints?
Answer Posted / priya
Constraints define the conditions or predictions under
which data is valid.
column level constraints are applicable to single column
only like if we want to make Unique constraint on column
level then as shoen below:-
<column Name><data type>Unique
At table level
Unique(<coulmn>,<column>);
Table level constraints means when constraints apply on
more than single column.
| Is This Answer Correct ? | 22 Yes | 6 No |
Post New Answer View All Answers
What happens to indexes if you drop a table?
What is hash cluster in oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
how the indexes are stored in the Oracle Database?
What is a cognitive schema?
query optmization techniques and quwry analyser+projects+ppts
State and explain about oracle instance?
Is there an oracle sql query that aggregates multiple rows into one row?
What are the execution control statements in oracle?
Explain about achiever in sql?
What is a nested table and how is it different from a normal table?
Difference between inner join vs where ?
Explain implicit cursor.
How to assign a table row to a record variable?