Differences

This shows you the differences between two versions of the page.

Link to this comparison view

dev:sql:examples:home [2010/07/02 06:45]
tdo
dev:sql:examples:home [2016/06/28 22:38] (current)
Line 1: Line 1:
 {{page>:top_add&nofooter&noeditbtn}} {{page>:top_add&nofooter&noeditbtn}}
-<html><div align="center"><span style="color:red">DRAFT</span></div></html> 
 ====== Omnidex SQL Examples ====== ====== Omnidex SQL Examples ======
 {{page>:sql_bar&nofooter&noeditbtn}} {{page>:sql_bar&nofooter&noeditbtn}}
 ===== $CONTAIN Function ===== ===== $CONTAIN Function =====
  
-  SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME,'fred,'SYNONYMS=ALL_GIVEN_NAMES')+  SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME,'fred,'SYNONYMS=ALL_GIVEN_NAMES')
 + 
 +  SELECT FIRST_NAME FROM CUSTOMERS WHERE  
 +      $CONTAINS(FIRST_NAME,'fred,'SYNONYMS','LIST=ALL_GIVEN_NAMES'); 
 + 
 +  SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME,  
 +     '(SYNONYMS(fred,"ALL_GIVEN_NAMES"))'); 
  
-  SELECT FIRST_NAME FROM CUSTOMERS WHERE \ 
-      $CONTAINS(FIRST_NAME,'fred,'SYNONYMS','LIST=ALL_GIVEN_NAMES') 
 ===== Qualify Statement ===== ===== Qualify Statement =====
  
Line 15: Line 18:
   QUALIFY CUSTOMERS WHERE FIRST_NAME = 'SYNONYMS(fred,,"LIST=ALL_GIVEN_NAMES")'   QUALIFY CUSTOMERS WHERE FIRST_NAME = 'SYNONYMS(fred,,"LIST=ALL_GIVEN_NAMES")'
  
-  SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME, \ +
-     '(SYNONYMS(fred,"ALL_GIVEN_NAMES"))') +
 ===== Searches ===== ===== Searches =====
 Example 1: Basic search Example 1: Basic search
Line 104: Line 106:
               PRF.DESCRIPTION               PRF.DESCRIPTION
 </code>               </code>              
- 
 ===== criteria shown with a crosstab of counts by cust_since and region ===== ===== criteria shown with a crosstab of counts by cust_since and region =====
  
-<code SQL>+<code>
 select        ORD.CUST_SINCE, \ select        ORD.CUST_SINCE, \
               ORD.REGION, \               ORD.REGION, \
 
Back to top
dev/sql/examples/home.1278053132.txt.gz · Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0