데이터베이스 질문과 답변
by pajama
[2021.02.04 19:47:58]
xml 함수를 쓰시면 됩니다~
with t as (
select '1/2' e from dual
)
select to_number(extractvalue(xmltype(dbms_xmlgen.getxml('select ' || e || ' as result from dual')),'/ROWSET/ROW/RESULT')) from t
by 문선린
[2021.02.05 07:50:03]
답변 감사드립니다.
by 마농
[2021.02.05 08:37:23]
WITH t AS
(
SELECT '1/2' e FROM dual
)
SELECT e
, TO_NUMBER(
dbms_xmlgen.getxmltype('SELECT ' || e || ' FROM dual').Extract('//text()')
) x
FROM t
;
) 버튼을 클릭하여 작성 하시면 됩니다.