Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Oracle regexp_like (Read 2491 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Oracle regexp_like
21.01.11 at 16:01:22
 
Oracle regexp_like
 
One can use the regexp_like function to match patterns in strings.
 
Example:
 
select count(*) from t where name not like '%TRA%' and name not like '%MEE%'
 
select count(*) from t where not regexp_like(name,'TRA|MEE')
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1