728x90
반응형
SELECT REGEXP_REPLACE('변경필드','(^[[:space:]]*|[[:space:]]*$)')
FROM DUAL;
SELECT 'TAB공백제거하기 ' sample_text
,regexp_replace('TAB공백제거하기 ','(^[[:space:]]*|[[:space:]]*$)') ch_text
FROM dual;

728x90
반응형
'ㄱWORK, ETC > Oracle' 카테고리의 다른 글
| Oracle Forms – Remove List Element from List Item (0) | 2023.06.30 |
|---|---|
| set_item_property BACKGROUND_COLOR 시 컬러색표시 (0) | 2023.05.23 |
| OPM inventory ITEM DFF SETUP (0) | 2023.02.21 |
| FND User Login History (0) | 2023.02.03 |
| GLOOAP: Open Period Status : Error (0) | 2023.01.30 |