INSERT INTO sfa_t_cir_ordercode
(
ordercodeid,
orderdate,
ordercode
)
VALUES
(
cast(sfa_f_new_uuid(CAST(random() * 100000 AS INTEGER)) AS uuid),
to_char(now(),'yyyy-mm-dd'),
iordercode
);
INSERT INTO sfa_t_cir_ordercode
(
ordercodeid,
orderdate,
ordercode
)
VALUES
(
cast(sfa_f_new_uuid(CAST(random() * 100000 AS INTEGER)) AS uuid),
to_char(now(),'yyyy-mm-dd'),
iordercode
);
