从SYS.XMLTYPE类型的column中,直接读取xpath所对应节点或者属性的值: select EXTRACTVALUE(t.xml_data, &nbs
CREATE USER DFL IDENTIFIED BY DFL DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 2 Roles for DFL GRANT DBA TO DFL WITH
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号