这里的\"是转义字符。sql字符串输出来是: select * from \"IIMSADMIN\".\"SCC_IIMS_NODETREE\"它在sqlplus worksheet中,能够正确查询结果。我把上面的sql换成: "select * from \"SCC_IIMS_NODETREE\"" "select * from IIMSADMIN.SCC_IIMS_NODETREE" "select * from SCC_IIMS_NODETREE" 都试过,结果一样。================ 不知道为什么?
上面错了,sql字符串输出来是: select * from "IIMSADMIN"."SCC_IIMS_NODETREE"
select * from \"IIMSADMIN\".\"SCC_IIMS_NODETREE\"它在sqlplus worksheet中,能够正确查询结果。我把上面的sql换成:
"select * from \"SCC_IIMS_NODETREE\""
"select * from IIMSADMIN.SCC_IIMS_NODETREE"
"select * from SCC_IIMS_NODETREE"
都试过,结果一样。================
不知道为什么?
select * from "IIMSADMIN"."SCC_IIMS_NODETREE"