Difference between revisions of "OE.ORDERS VIEW (view)"
Line 10: | Line 10: | ||
<pre> | <pre> | ||
− | CREATE OR REPLACE SELECT | + | CREATE OR REPLACE VIEW OE.ORDERS_VIEW AS |
+ | SELECT | ||
order_id, | order_id, | ||
TO_DATE(TO_CHAR(order_date,'DD-MON-YY HH:MI:SS'),'DD-MON-YY HH:MI:SS') ORDER_DATE, | TO_DATE(TO_CHAR(order_date,'DD-MON-YY HH:MI:SS'),'DD-MON-YY HH:MI:SS') ORDER_DATE, |
Revision as of 21:10, 24 August 2009
wikibot
view | OE.ORDERS_VIEW |
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