Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

OE ORDERS_VIEW (view)

RSS
Modified on 2011/08/27 12:10 by wikibot Categorized as Uncategorized

wikibot

ViewOE.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

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.