OE.ORDERS VIEW (view)

From dbscript Online Help
Revision as of 08:28, 11 February 2010 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

View OE.ORDERS_VIEW


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