create table ORDER_EVENT_DETAIL
(
order_event_detail_uid NUMBER(38) not null,
dist_ext_order_dtl_uid NUMBER(38),
status VARCHAR2(50),
trans_uid NUMBER(38),
dist_units NUMBER(32,16),
dist_units_nic NUMBER(32,16),
forfeited_units NUMBER(32,16),
settlement_price NUMBER(32,16)
)
Table created.
INSERT INTO ORDER_EVENT_DETAIL
(ORDER_EVENT_DETAIL_UID
,DIST_EXT_ORDER_DTL_UID
,STATUS
,TRANS_UID
,DIST_UNITS
,DIST_UNITS_NIC
,FORFEITED_UNITS
,SETTLEMENT_PRICE)
VALUES
(1245
,1245
,'OPEN'
,45896
,4637.4120000000000000
,37.4120000000000000
,0.0000000000000000
,1.0000000000000000)
1 row(s) inserted.
select * from ORDER_EVENT_DETAIL
ORDER_EVENT_DETAIL_UID | DIST_EXT_ORDER_DTL_UID | STATUS | TRANS_UID | DIST_UNITS | DIST_UNITS_NIC | FORFEITED_UNITS | SETTLEMENT_PRICE | 1245 | 1245 | OPEN | 45896 | 4637.412 | 37.412 | 0 | 1 |
---|
UPDATE ORDER_EVENT_DETAIL oed
SET oed.dist_units = 4637.4120000000001234
,oed.dist_units_nic = 37.4120000000000847
WHERE oed.order_event_detail_uid = 1245
1 row(s) updated.
select * from ORDER_EVENT_DETAIL
ORDER_EVENT_DETAIL_UID | DIST_EXT_ORDER_DTL_UID | STATUS | TRANS_UID | DIST_UNITS | DIST_UNITS_NIC | FORFEITED_UNITS | SETTLEMENT_PRICE | 1245 | 1245 | OPEN | 45896 | 4637.4120000000001234 | 37.4120000000000847 | 0 | 1 |
---|