Oracle key help continued.

From: <jlj_at_vms.cis.pitt.edu>
Date: 1997/03/25
Message-ID: <5h8jqk$d3r@usenet.srv.cis.pitt.edu>#1/1

Hi again,

I did not think to show my scripts to the key problem when I first posted. So this post has the example I related from the last post.

DROP TABLE glsubcds;
DROP TABLE glrates;

CREATE TABLE glrates
(rate_letter VARCHAR2(1) PRIMARY KEY,

  rt_beg_dt       DATE          NOT NULL, 
  rt_end_dt       DATE          NOT NULL,
  rate            NUMBER(04)    NOT NULL, 

 UNIQUE (rate_letter, rt_beg_dt));

DESCRIBE glrates;

CREATE TABLE glsubcds
(subcd VARCHAR2(4) PRIMARY KEY,
  subcd_letter VARCHAR2(1),
   CONSTRAINT fk_subcd_letter1
   FOREIGN KEY (subcd_letter)
   REFERENCES glrates(rate_letter),
   subcd_master VARCHAR2(4) NOT NULL);

DESCRIBE glsubcds;

Thanks again,

Jim Jones Received on Tue Mar 25 1997 - 00:00:00 CST