Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Data Definition LangRSS Feeds

Example to add constraint in a table

Posted By: Adalgisa Fischer     Category: Oracle     Views: 1841

This article provides an example to add constraint in a sc table i.e marks must be between 0 to 100.

Code for Example to add constraint in a table in Oracle

altertable sc addconstraint check_sc_marks check(marks between 0 and 100);
  
Share: 

 
 
 

Didn't find what you were looking for? Find more on Example to add constraint in a table Or get search suggestion and latest updates.

Adalgisa Fischer
Adalgisa Fischer author of Example to add constraint in a table is from Frankfurt, Germany.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!