Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
sss
--a) create table shipping_service( ship_ID decimal(12), name varchar(32), primary key(ship_ID) ); create table Package( package_ID decimal(12), description varchar(25), date_delivered date, ship_ID decimal(12) references shipping_service(ship_ID), primary key(package_ID)); insert into shipping_service(ship_ID, name) VALUES ('1001', 'Kazpost'), ('1002', 'DHL'), ('1003', 'FedEx'), ('1004', 'PonyExpress'); insert into Package(package_ID, description, date_delivered, ship_ID) VALUES ('9001','IT devices', '25-May-2019', '1001'), ('9002','fragile box', '15-June-2019', '1002'), ('9003','sport equipment', '20-Apr-2018', '1003'), ('9004','express mail', '22-July-2019', null)
run
|
edit
|
history
|
help
0
loggin_trigger-audit
Movie Rating SQL Analysis Project
Postgres Trigger
post
hell
SQL2_CLASS
test
conditionally add “another row” in SQL Server?
Webiste SQL Analysis
Movie Rating SQL Analysis Project