Page History: OE ORDERS_VIEW (view)
Compare Page Revisions
Page Revision: 2010/06/24 07:59
wikibot
Source
CREATE OR REPLACE VIEW OE.ORDERS_VIEW AS
SELECT
order_id,
TO_DATE(TO_CHAR(order_date,'DD-MON-YY HH:MI:SS'),'DD-MON-YY HH:MI:SS') ORDER_DATE,
order_mode,
customer_id,
order_status,
order_total,
sales_rep_id,
promotion_id
FROM orders
References
Dependency Type | Object Type | Referenced Object |
Select | Table | OE.ORDERS |