Thread: How do I ensure that a field in a table must contain values within a specific range?
View Single Post
  #2 (permalink)  
Old 05-24-2006, 03:46 AM
irfanhab irfanhab is offline
Junior Member
  
Join Date: May 2006
Posts: 10
irfanhab is on a distinguished road
Default Oracle answer. Re: How do I ensure that a field in a table must contain values within a specific range?
Say your table is called "Employee"
[sql]
alter table Employee add check (salary between 5000 and 120000);
[/sql]
Reply With Quote