Editing OE.CUSTOMERS VIEW (view)

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''view
| OE.CUSTOMERS_VIEW
|-
|}

<pre>

</pre>
@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|- valign="top"
+|-
-| '''View
+| '''view
 | OE.CUSTOMERS_VIEW
+|-
 |}
-=== Source ===
 <pre>
-CREATE OR REPLACE VIEW OE.CUSTOMERS_VIEW AS
-SELECT
-  c.customer_id,
-  c.cust_first_name,
-  c.cust_last_name,
-  c.cust_address.street_address street_address,
-  c.cust_address.postal_code postal_code,
-  c.cust_address.city city,
-  c.cust_address.state_province state_province,
-  co.country_id,
-  co.country_name,
-  co.region_id,
-  c.nls_language,
-  c.nls_territory,
-  c.credit_limit,
-  c.cust_email,
-  substr(get_phone_number_f(1,phone_numbers),1,25) Primary_Phone_number,
-  substr(get_phone_number_f(2,phone_numbers),1,25) Phone_number_2,
-  substr(get_phone_number_f(3,phone_numbers),1,25) Phone_number_3,
-  substr(get_phone_number_f(4,phone_numbers),1,25) Phone_number_4,
-  substr(get_phone_number_f(5,phone_numbers),1,25) Phone_number_5,
-  c.account_mgr_id,
-  c.cust_geo_location.sdo_gtype location_gtype,
-  c.cust_geo_location.sdo_srid location_srid,
-  c.cust_geo_location.sdo_point.x location_x,
-  c.cust_geo_location.sdo_point.y location_y,
-  c.cust_geo_location.sdo_point.z location_z
-FROM
-  countries co,
-  customers c
-WHERE
-  c.cust_address.country_id = co.coun
 </pre>