Q & A

Re: Re: Re: 오렌지 특수문자 보이고, 안보이고 차이 문의

Date2021.03.22 / Hit : 9610
Orange 4.0 || 4.0.1 ( Build:43 ) DBA Edition Enterprise License

2021/03/22 16:05:02

SQL> SELECT EML_SND_NO, TO_EML_CTNT
, rawtohex(cast(TO_EML_CTNT as varchar2(100)))
,dbms_lob.getlength(TO_EML_CTNT) as lob_size
,DUMP(cast(TO_EML_CTNT as varchar2(100))) AS CODE
,cast(TO_EML_CTNT as varchar2(100))
,ASCII(cast(TO_EML_CTNT as varchar2(100)))
rawtohex(TO_EML_CTNT)
FROM COM_EML_SND_INFO
WHERE EML_SND_NO IN (
2021030970229067EML,
2021030970230164EML,
2021030970229070EML,
2021030970230167EML,
2021031978772498EML,
2021011922210096EML)

EML_SND_NO TO_EML_CTNT LOB_SIZE CODE
- -
2021011922210096EML se.dl.buh.schenkerocean.invoicing@dbschenker.com 49 Typ=1 Len=49: 115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970229067EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970229070EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970230164EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970230167EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021031978772498EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59

6 rows selected.

Execution Time: 00:00:00.94
Elapsed Time: 00:00:01.156


Orange 7.0 // Version 7.0.1 ( Build : 116 _ DBA Edition Enterprise License

-[Start Time: 2021/03/22 16:05:36]-
SQL> SELECT EML_SND_NO, TO_EML_CTNT
, rawtohex(cast(TO_EML_CTNT as varchar2(100)))
,dbms_lob.getlength(TO_EML_CTNT) as lob_size
,DUMP(cast(TO_EML_CTNT as varchar2(100))) AS CODE
,cast(TO_EML_CTNT as varchar2(100))
,ASCII(cast(TO_EML_CTNT as varchar2(100)))
rawtohex(TO_EML_CTNT)
FROM COM_EML_SND_INFO
WHERE EML_SND_NO IN (
2021030970229067EML,
2021030970230164EML,
2021030970229070EML,
2021030970230167EML,
2021031978772498EML,
2021011922210096EML)

EML_SND_NO TO_EML_CTNT LOB_SIZE CODE
- -
2021011922210096EML se.dl.buh.schenkerocean.invoicing@dbschenker.com 49 Typ=1 Len=49: 115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970229067EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970229070EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970230164EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021030970230167EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59
2021031978772498EML ?se.dl.buh.schenkerocean.invoicing@dbschenker.com 50 Typ=1 Len=52: 226,128,139,115,101,46,100,108,46,98,117,104,46,115,99,104,101,110,107,101,114,111,99,101,97,110,46,105,110,118,111,105,99,105,110,103,64,100,98,115,99,104,101,110,107,101,114,46,99,111,109,59

6 rows selected.
  • 대표전화
    1660-1675

  • 기술 문의
    02-6931-1734

  • 오렌지 문의
    070-8666-8175

  • 라이선스 문의
    02-6931-1728