Results for SOUNDEX


1 to 20 of 25 results. Prev  Next


Reference, 10g Release 1 (10.1)

3 Oracle Text CONTAINS Query Operators

soundex (!)Use the soundex (!) operator to expand queries to include words that have similar sounds; that is … a hard worker who.. Language Soundex works best for languages that use a 7-bit character set, such … column and the query expression contains a soundex operator, Oracle Text operates on the base-letter form of the query.

SQL Reference, 10g Release 1 (10.1)

SOUNDEX

SOUNDEXSyntax soundex::= Description of the illustration soundex.gif Purpose SOUNDEX returns a character … last_name, first_name FROM hr.employees WHERE SOUNDEX(last_name) = SOUNDEX('SMYTHE'); LAST_NAME

Application Developer's Guide, 10g Release 1 (10.1)

4 Querying

4.2.5 Fuzzy, Stem, Soundex, Wildcard and Thesaurus Expansion Operators, soundex, and thesaurus. See Also: Oracle Text Reference for more information about using these

Reference, 10g Release 1 (10.1)

3 Oracle Text CONTAINS Query Operators

3.1.2 Group 2 Operators and Charactersto lowest: Wildcard Characters stem ($) Fuzzy soundex (!)

Reference, 10g Release 1 (10.1)

A Oracle Text Result Tables

Options Value DescriptionTable A-3 EXPLAIN Table OPTIONS Column Options Value Description ($) Stem (?) Fuzzy (!) Soundex (T

Reference, 10g Release 1 (10.1)

3 Oracle Text CONTAINS Query Operators

3 Oracle Text CONTAINS Query OperatorsTerm (NT, NTG, NTP, NTI) NEAR (;) NOT (~) OR (|) Preferred Term (PT) Related Term (RT) soundex

Reference, 10g Release 1 (10.1)

3 Oracle Text CONTAINS Query Operators

EQUIValence (=)than all other operators except the expansion operators (fuzzy, soundex, stem).

Application Developer's Guide, 10g Release 1 (10.1)

4 Querying

4.1.10 Query Explain Planstem, wildcard, thesaurus, fuzzy, soundex, or ABOUT query. Parse trees also show the following

Reference, 10g Release 1 (10.1)

4 Special Characters in Oracle Text Queries

4.1 Grouping Charactersthe expansion operators (fuzzy, soundex, stem). The beginning of a group of terms and operators is

Reference, 10g Release 1 (10.1)

10 CTX_QUERY Package

EXPLAINfor stem, wildcard, thesaurus, fuzzy, soundex, or about queries. Parse trees also show the following

Reference, 10g Release 1 (10.1)

4 Special Characters in Oracle Text Queries

4.3 Reserved Words and CharactersTerm (none) $ stem (none) ! soundex SQE (none) Stored Query Expression SYN (none) Synonym (none

Developer's Guide, 10g Release 1 (10.1)

9 Full Text Search Over XML

Full Text Search-based operators MINUS(-) or threshold(>) Selective, corpus-based expansion operators FUZZY(?) or soundex

Reference, 10g Release 1 (10.1)

10 CTX_QUERY Package

index_namecriteria for selecting rows. When you include a wildcard, fuzzy, or soundex operator in text_query … soundex (!) expression feedback does not account for lazy deletes as in regular queries. explain_table

User's Guide and Reference, 10g Release 1 (10.1)

2 Fundamentals of the PL/SQL Language

Summary of PL/SQL Built-In FunctionsSOUNDEX SUBSTR SUBSTR2 SUBSTR4 SUBSTRB SUBSTRC TRANSLATE TRIM UNISTR UPPER CHARTOROWID CONVERT

Error Messages, 10g Release 1 (10.1)

62 DRG-10000 to DRG-52210

DRG-50947: ABOUT clause not allowed without a theme indexCause: Stemming, fuzzy match and soundex not allowed for theme index Action: Rewrite query DRG-50947: ABOUT clause not allowed without a theme index

Constant Field Values (Oracle Ultra Search Java API Reference), 10g Release 1 (10.1)

CtxContains (Oracle Ultra Search Java API Reference)

oracle.ultrasearch.query Class CtxContainsas thesaurus (SYN), theme (ABOUT), soundex (!), stemming ($), in its query language. Any valid

SQL Reference, 10g Release 1 (10.1)

SQL Functions

Single-Row FunctionsREGEXP_REPLACE REGEXP_SUBSTR REPLACE RPAD RTRIM SOUNDEX SUBSTR TRANSLATE TREAT TRIM UPPER Character

SQL Quick Reference, 10g Release 1 (10.1)

2 SQL Functions

Syntax for SQL Functions) SIGN SIGN(n) SIN SIN(n) SINH SINH(n) SOUNDEX SOUNDEX(char) SQRT SQRT(n) STATS_BINOMIAL_TEST

Reference, 10g Release 1 (10.1)

1 Oracle Text SQL Statements and Operators

structured_query Specify the structured conditions and the ORDER BY clause. There must exist an index…','')>0 order by pk; PROMPT PROMPT fuzzy: query = !sail PROMPT should match all soundex variations

Reference, 10g Release 1 (10.1)

3 Oracle Text CONTAINS Query Operators

orderproduce words, phrases, or EQUIV. These include: soundex fuzzy wildcards stem Backward Compatibility NEAR


Was this page helpful?