sQL tUNING
-
编辑 删除
Oracle 10g正则表达式
ORACLE终于在10G中提供了对正则表达式的支持，以前那些需要通过LIKE来进行的复杂的匹配就可以通过使用正则表达式更简单的实现。ORACLE中的支持正则表达式的函数主要有下面四个： 1，REGEXP_LIKE ：与LIKE的...
-
编辑 删除
Global Temporary Tables
Global Temporary TablesApplications often use some form. of temporary data store for processes that are to complicated to complete in a single pass. Often, these temporary stores are defined as datab...
-
编辑 删除
1. simple search
1. simple search (only one table)Table 2-1. Search Condition Point Counts for OperatorsOperator Points = 10 > 5 >= 5 < 5 <= 5 LIKE 3 <> 0 Table 2-2. Search C...
