1 Replies - 885 Views - Last Post: 18 April 2015 - 08:36 AM

#1 gamed2d  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 01-April 15

setting create table input range

Posted 01 April 2015 - 02:32 PM

below, I have create a table using oracle sql.

How can I change so that number of credits for a course is always between 0 and 6.

I think there is a keywork for it but I can't seem to find it.

CREATE TABLE COURSES
  (COURSE VARCHAR(6),
   DESCRIPTION VARCHAR(60),
   CREDITS INT,
   CONSTRAINT pk PRIMARY KEY (COURSE));

Is This A Good Question/Topic? 0
  • +

Replies To: setting create table input range

#2 ndc85430  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 613
  • View blog
  • Posts: 2,584
  • Joined: 13-June 14

Re: setting create table input range

Posted 18 April 2015 - 08:36 AM

You can use check.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1