|
|
| Line 21: |
Line 21: |
| | FROM orders | | FROM orders |
| | </pre> | | </pre> |
| − |
| |
| − | === References ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Dependency Type
| |
| − | | '''Object Type
| |
| − | | '''Referenced Object
| |
| − |
| |
| − | |- valign="top"
| |
| − | | Select
| |
| − | | Table
| |
| − | | [[OE.ORDERS_(table)|OE.ORDERS]]
| |
| − |
| |
| − | |}
| |
Latest revision as of 10:35, 27 August 2011
wikibot[edit]
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
