Notice
Recent Posts
Recent Comments
Link
์ผ | ์ | ํ | ์ | ๋ชฉ | ๊ธ | ํ |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | |
7 | 8 | 9 | 10 | 11 | 12 | 13 |
14 | 15 | 16 | 17 | 18 | 19 | 20 |
21 | 22 | 23 | 24 | 25 | 26 | 27 |
28 | 29 | 30 | 31 |
Tags
- poi monitorjbl
- xssreader
- fullcalendar js
- swift ๋ฉ๋ชจ์ฅ ๋ง๋ค๊ธฐ
- monitorjbl
- ์ ์์๋ช ๊ธฐ๋ฅ๊ตฌํ
- ์ ์์๋ช ๊ฐ๋ฐ
- jxls ์์
- monitorjbl ์์
- xcode swift memo
- Oracle
- Xcode
- spring annotation
- xssfworkbook
- poi ๋์ฉ๋
- outofmemoryerror ๋ฐฉ์ง
- PostgreSQL
- jxls
- xcode12.5.1
- js ์ ์์๋ช
- ๋ฌ๋ ฅ๊ธฐ๋ฅ๊ฐ๋ฐ
- xlsx-streamer
- swift ๊ณ์ฐ๊ธฐ
- MSsql
- ๋์ฉ๋์์ ์ ๋ก๋
- opcpackage
- Swift
- js๋ฌ๋ ฅ
- mysql
- ios app ๊ฐ๋ฐ
Archives
- Today
- Total
web developer๐ฉ๐ป๐ป
[Oracle] ๋ค์ค LIKE OR / REGEXP_LIKE // IN ๋ณธ๋ฌธ
728x90
1. LIKE OR ์ฌ์ฉ
LIKE๋ฅผ ์ฌ์ฉํ์ฌ ๋ค์ค์ผ๋ก ๊ฒ์ํ๊ธฐ ์ํด์๋ OR ์ฐ์ฐ์๋ฅผ ์ฌ์ฉํ๋ค.
WHERE COD_CDE LIKE 'AAA011'
AND COD_YER LIKE '2018'
WHERE (COD_CDE LIKE 'AAA011' OR COD_YER LIKE 2018)
2. REGEXP_LIKE ์ ๊ท์ ์ฌ์ฉ (์ค๋ผํด 10g๋ถํฐ ์ฌ์ฉ)
REGEXP_LIKE - ๋จ์ํ LIKE๋ฅผ ๋์ด ์ ๊ท์ ์ผ์น๋ฅผ ์ํํ๋ ๋ฐ ์ฌ์ฉ
WHERE REGEXP_LIKE(COD_CDE, 'AAA011|AAA017|AAA018')
3. IN์ ์ฌ์ฉ
WHERE COD_CDE IN ('AAA011','AAA017','AAA018')