What is a constraint. Types of constraints ?
Answer Posted / samuvel
Constraint is a restriction on table
Types:
1)Column Constraints:applicable for column level
i)unique ii) not null
2)Table constraints:applicable for table level
1)primary key ii) foreign key d. check
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
Where can I learn sql for free?
How can I get the number of records affected by a stored procedure?
How to return an array from java to pl/sql?
What is the difference between function and procedure in pl/sql?
how to calculate expressions with sql statements? : Sql dba
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Does oracle roll back the transaction on an error?
what is table? : Sql dba
How to process query result in pl/sql?
How to run sql commands in sql*plus?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What is server name sql?
Which certification is best for sql?
What is the importance of sqlcode and sqlerrm?
How long will it take to learn pl sql?