Escape keyword analysis in Oracle

xiaoxiao2021-03-06  97

Definition: Escape keywords are often used to make certain special characters, such as wildcards: '%', '_' escape as they

The meaning of characters, the defined escape character is usually used to use '/', but other symbols can also be used.

Example:

SQL> SELECT * from T11 Where name Like '% _%'

Name ---------- AA_AAAASQL> SELECT * from T11 Where name Like '% / _%' escape '/';

Name ---------- AA_A

Note: If it is '/' as a search character, you must use '/' as an escape character, the front oblique weapon is also .Select * from wan_test where psid like '% //%' Escape '/'

转载请注明原文地址:https://www.9cbs.com/read-123074.html

New Post(0)