oracle - How to create table with changing the FK column's name in multiple columns in one table? -
create table airport ( apcode char(3), apname varchar(255), city varchar(30), state varchar(30), country varchar(30), primary key (apcode) ); create table flight ( fnumber varchar(20) primary key, outbound_apcode char(3), inbound_apcode char(3), constraint outbound_apcod foreign key (apcode) references airport(apcode), constraint inbound_apcode foreign key (apcode) references airport(apcode) apcode char(3),-- how not create column in table. --insert flight values (fnumber,outbound_apcode,inbound_apcode). );
Comments
Post a Comment