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
How to store only time; not date and time?
What is oracle rowcount?
What do you mean by cdb and pdb in oracle 12c?
What is the use of file param in imp command?
What is the relationship among database, tablespace and data file?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What are temporal data types in oracle?
How to connect asp pages to oracle servers?
Who developed oracle & when?
How to create an initialization parameter file?
How does one get the view definition of fixed views/tables?
What is index in Oracle?
Please explain joins in oracle?
What do you understand by database schema and what does it hold?
Can you assign multiple query result rows to a variable?