Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
dev:sql:examples:home [2010/07/02 06:46]
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 \ +  SELECT FIRST_NAME FROM CUSTOMERS WHERE  
-      $CONTAINS(FIRST_NAME,'​fred,'​SYNONYMS','​LIST=ALL_GIVEN_NAMES'​)+      $CONTAINS(FIRST_NAME,'​fred,'​SYNONYMS','​LIST=ALL_GIVEN_NAMES'​);
  
-  SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME, ​\ +  SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME,​  
-     '​(SYNONYMS(fred,"​ALL_GIVEN_NAMES"​))'​) ​+     '​(SYNONYMS(fred,"​ALL_GIVEN_NAMES"​))'​)
  
 ===== Qualify Statement ===== ===== Qualify Statement =====
Line 107: 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.1278053162.txt.gz · Last modified: 2016/06/28 22:38 (external edit)