sslug-teknik team mailing list archive

[MONZ <monz@xxxxxxxxx>]

Martin Wahlen wrote:
> 
> Hejsan, jag sitter och leker med min Oracle 8.0.5 för linux och undrar om
> man kan göra en
> SELECT en_clob_row FROM en_tabell WHERE en_clob_item LIKE '%uttryck' ?

Fra min efterhånden ret gamle Oracle 5.1 SQL Reference Manual:

Syntax: SELECT ... WHERE ... LIKE ...

The special character "%" matches any number of characters, including zero
characters.
LIKE may be used in any logical expression involving char values.
When LIKE is used to search an indexed coloumn for a pattern, the speed
advantage of indexing is lost if the first character in the pattern is "%" or
"_".
-- 
Mogens Valentin - Mail: monz@xxxxxxxxx - Website: http://www.danbbs.dk/~monz/ 
Web, Programming, Network, Security - Guides for Linux, Xwindows, Netscape...
Skaane/Sjaelland Linux User Group (now 3900+ members!) - http://www.sslug.dk/
Get a grip, get http://www.linux.org with Gnome/Enlightment and free software