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
