Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table Store(
Store_ID integer primary key,
Warehouse_ID integer not null,
Employee_ID integer,
Owner_name varchar2 (15) not null,
Store_hours varchar (20) not null,
Store_name varchar (20) not null,
Store_Address varchar2 (50) not null);
insert into Store
values (101, 1001, NULL , 'Grant Campbell', '7:00am - 10:00pm', 'Papakura', '331-345 Great South Road, Takanini, Auckland, 2110');
1 rows affected

select *
from store;


STORE_ID
WAREHOUSE_ID
EMPLOYEE_ID
OWNER_NAME
STORE_HOURS
STORE_NAME
STORE_ADDRESS


101
1001
null
Grant Campbell
7:00am - 10:00pm
Papakura
331-345 Great South Road, Takanini, Auckland, 2110