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

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -