INSERT INTO Shipment $($ShipmentID$,$ CustomerID, ContainerType, ContainerCount, ShipmentStatus, QuotedPrice, BookingDate, SailingDate, ArrivalDate, CollectionDate, CancellationDate, CancellationRefund, RouteID$)$

SELECT $1,1,\text{'}40-$Foot', $2,$ 'Delivered', $3000\mathrm{.}00,$ TO$\_$DATE$(\text{'}2021-06-21\text{'},\text{'}$YYYY$-$MM$-$DD$\text{'}),$ TO$\_$DATE$(\text{'}2021-06-21\text{'},\text{'}$YYYY$-$MM$-$DD$\text{'}),$ TO$\_$DATE$(\text{'}2021-06-30\text{'},\text{'}$YYYY$-$MM$-$DD$\text{'}),$ TO$\_$DATE$(\text{'}2021-07-05\text{'},\text{'}$YYYY$-$MM$-$DD$\text{'}),$ NULL, NULL, $1$ FROM DUAL UNION ALL