|
||
0
0
happycog
À§Ä¡°¡ Á¤È®ÇÏÁö ¾ÊÀ¸´Ï substrÀº ¾ÈµÉµíÇÏ°í like¹®À¸·Î ÇÏ¸é µÉ°Å °°Àºµ¥¿ä
2023-06-30
|
0
0
¹èÆ®¸Ç½Ò±¹¼ö
ÀÌÁ¤µµ´Â chat gptÇÑÅ× Áú¹®Çϸé 1Ãʸ¸¿¡ ¾Ë·ÁÁÙ°Ì´Ï´Ù |
0
0
´ß²¿Ä¡¸Å´Ï¾Æ
ƯÁ¤ ¹®ÀÚ »çÀÌ¿¡ ÀÖ´Â µ¥ÀÌÅ͸¦ °¡Á®¿À·Á¸é `SUBSTR` ÇÔ¼ö¿Í `INSTR` ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© ¹®ÀÚ¿À» ÃßÃâÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, ´ÙÀ½°ú °°Àº Äõ¸®¸¦ »ç¿ëÇÏ¿© ƯÁ¤ ¹®ÀÚ »çÀÌ¿¡ ÀÖ´Â µ¥ÀÌÅ͸¦ ÃßÃâÇÒ ¼ö ÀÖ½À´Ï´Ù.
```SQL SELECT SUBSTR(column_name, INSTR(column_name, 'start_char') + 1, INSTR(column_name, 'end_char') - INSTR(column_name, 'start_char') - 1) FROM table_name; ```
À§ÀÇ Äõ¸®¿¡¼ `column_name`Àº µ¥ÀÌÅÍ°¡ Æ÷ÇÔµÈ ¿ÀÇ À̸§ÀÌ°í, `start_char`¿Í `end_char`´Â µ¥ÀÌÅÍ°¡ Æ÷ÇÔµÈ ¹®ÀÚ »çÀÌÀÇ ½ÃÀÛ ¹®ÀÚ¿Í ³¡ ¹®ÀÚÀÔ´Ï´Ù. ÀÌ Äõ¸®´Â `SUBSTR` ÇÔ¼ö¿Í `INSTR` ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© ½ÃÀÛ ¹®ÀÚ¿Í ³¡ ¹®ÀÚ »çÀÌÀÇ µ¥ÀÌÅ͸¦ ÃßÃâÇÕ´Ï´Ù©ö.
¶ÇÇÑ, Á¤±Ô½ÄÀ» »ç¿ëÇÏ¿© ƯÁ¤ ¹®ÀÚ »çÀÌ¿¡ ÀÖ´Â µ¥ÀÌÅ͸¦ ÃßÃâÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ¿À¶óŬ¿¡¼´Â `REGEXP_SUBSTR` ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© Á¤±Ô½ÄÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅ͸¦ ÃßÃâÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, ´ÙÀ½°ú °°Àº Äõ¸®¸¦ »ç¿ëÇÏ¿© ƯÁ¤ ¹®ÀÚ »çÀÌ¿¡ ÀÖ´Â µ¥ÀÌÅ͸¦ ÃßÃâÇÒ ¼ö ÀÖ½À´Ï´Ù.
```SQL SELECT REGEXP_SUBSTR(column_name, 'start_char(.*)end_char', 1, 1, NULL, 1) FROM table_name; ```
À§ÀÇ Äõ¸®¿¡¼ `column_name`Àº µ¥ÀÌÅÍ°¡ Æ÷ÇÔµÈ ¿ÀÇ À̸§ÀÌ°í, `start_char`¿Í `end_char`´Â µ¥ÀÌÅÍ°¡ Æ÷ÇÔµÈ ¹®ÀÚ »çÀÌÀÇ ½ÃÀÛ ¹®ÀÚ¿Í ³¡ ¹®ÀÚÀÔ´Ï´Ù. ÀÌ Äõ¸®´Â `REGEXP_SUBSTR` ÇÔ¼öÀÇ µÎ ¹ø° Àμö·Î Àü´ÞµÈ Á¤±Ô½ÄÀ» »ç¿ëÇÏ¿© ½ÃÀÛ ¹®ÀÚ¿Í ³¡ ¹®ÀÚ »çÀÌÀÇ µ¥ÀÌÅ͸¦ ÃßÃâÇÕ´Ï´Ù©÷.
ÀÚ¼¼ÇÑ ³»¿ëÀº ÂüÁ¶ ¸µÅ©©ö©÷¿¡¼ È®ÀÎÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.
Ãâó: Bing°úÀÇ ´ëÈ, 2023. 6. 30. (1) How to get text from between characters in oracle sql. https://stackoverflow.com/questions/17427038/how-to-get-text-from-between-characters-in-oracle-sql. (2) Oracle SQL: Extracting text between two characters. https://stackoverflow.com/questions/50004535/oracle-sql-extracting-text-between-two-characters. (3) How to Extract a Substring From a String in Oracle/SQLite. https://learnsql.com/cookbook/how-to-extract-a-substring-from-a-string-in-oracle-sqlite/. (4) REGEXP_SUBSTR - Oracle Help Center. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/REGEXP_SUBSTR.html.
êGPT°Ë»ö°á°ú |
0
0
ŹŹÀÌÀÌ
SELECT REGEXP_SUBSTR('123456789sip:01012345678@tag===========','[^:@]+',1,1)
, REGEXP_SUBSTR('123456789sip:01012345678@tag===========','[^:@]+',1,2)
FROM DUAL
|
|
|
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | ¸ñ·Ïº¸±â |