Answers for "HOW TO ALTER TABLE IN ORACLE TO GIVE FOREIGN KEY"

SQL

0

foreign key plsql

CREATE TABLE supplier
( supplier_id numeric(10) not null,
  supplier_name varchar2(50) not null,
  contact_name varchar2(50),
  CONSTRAINT supplier_pk PRIMARY KEY (supplier_id)
);

CREATE TABLE products
( product_id numeric(10) not null,
  supplier_id numeric(10) not null,
  CONSTRAINT fk_supplier
    FOREIGN KEY (supplier_id)
    REFERENCES supplier(supplier_id)
);

Posted by: Guest on April-01-2020

Code answers related to "HOW TO ALTER TABLE IN ORACLE TO GIVE FOREIGN KEY"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#