ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
OE.PRODUCTS_(view)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''View''' | OE.PRODUCTS |} === Source === {{{{<nowiki> CREATE OR REPLACE VIEW OE.PRODUCTS AS SELECT i.product_id , d.language_id , CASE WHEN d.language_id IS NOT NULL THEN d.translated_name ELSE TRANSLATE(i.product_name USING NCHAR_CS) END AS product_name , i.category_id , CASE WHEN d.language_id IS NOT NULL THEN d.translated_description ELSE TRANSLATE(i.product_description USING NCHAR_CS) END AS product_description , i.weight_class , i.warranty_period , i.supplier_id , i.product_status , i.list_price , i.min_price , i.catalog_url FROM product_information i , product_descriptions d WHERE d.product_id (+) = i.product_id AND d.language_id (+) = sys_context('USERENV','LANG') </nowiki>}}}}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.