求不用with来改写下面的sql sql 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SELECT PATH_LEVEL, FULL_PATH, NODE_ID, NAME, PARENT_ID, CHANGE_TIME, PERFORMER, REPOSITORY_ID, NODE_TYPE, OWNER, DOCUMENT_TYPE_ID, CONTENT_LENGHT, CONTENT_TYPE, DOC_COMMENT, DOC_TYPE_CODE, DOC_TYPE_NAME, SOURCE_URL FROM (SELECT 0 AS PATH_LEVEL, CAST('/' + NAME AS VARCHAR(MAX)) AS FULL_PATH, NODE_ID, NAME, PARENT_ID, CHANGE_TIME, PERFORMER, REPOSITORY_ID, NODE_TYPE, OWNER, DOCUMENT_TYPE_ID, CONTENT_LENGHT, CONTENT_TYPE, DOC_COMMENT, DOC_TYPE_CODE, DOC_TYPE_NAME, SOURCE_URL FROM DOCV_NODE WHERE PARENT_ID IS NULL UNION ALL SELECT B.PATH_LEVEL + 1 AS PATH_LEVEL, CAST(B.FULL_PATH + '/' + A.NAME AS VARCHAR(MAX)) AS FULL_PATH, A.NODE_ID, A.NAME, A.PARENT_ID, A.CHANGE_TIME, A.PERFORMER, A.REPOSITORY_ID, A.NODE_TYPE, A.OWNER, A.DOCUMENT_TYPE_ID, A.CONTENT_LENGHT, A.CONTENT_TYPE, A.DOC_COMMENT, A.DOC_TYPE_CODE, A.DOC_TYPE_NAME, A.SOURCE_URL FROM DOCV_NODE A INNER JOIN PATH B ON B.NODE_ID = A.PARENT_ID) with 在9i中就已经支持了,只是10g还不知道with的别名中对字段名的定义把with path() 这里()部分去掉就Ok了 oracle 数据导入问题 oracle数据表导出 急!哪位高手帮忙把这个函数由SQL转为Oracle的版本 求SQL语句(两个表,分组,统计) oracel中的or模式的sql语句该怎么写? LINUX下,安装ORACLE问题 高分求:Oracle8i到Oracle9i的升级方案 新年好啊!请教各位高手一个问题? 请问 oracle企业管理器中没有内容 oracle用户对于表操作的权限判断 pl/sq里面建立的存储过程,出错,求大神帮忙
SELECT PATH_LEVEL,
FULL_PATH,
NODE_ID,
NAME,
PARENT_ID,
CHANGE_TIME,
PERFORMER,
REPOSITORY_ID,
NODE_TYPE,
OWNER,
DOCUMENT_TYPE_ID,
CONTENT_LENGHT,
CONTENT_TYPE,
DOC_COMMENT,
DOC_TYPE_CODE,
DOC_TYPE_NAME,
SOURCE_URL
FROM (SELECT 0 AS PATH_LEVEL,
CAST('/' + NAME AS VARCHAR(MAX)) AS FULL_PATH,
NODE_ID,
NAME,
PARENT_ID,
CHANGE_TIME,
PERFORMER,
REPOSITORY_ID,
NODE_TYPE,
OWNER,
DOCUMENT_TYPE_ID,
CONTENT_LENGHT,
CONTENT_TYPE,
DOC_COMMENT,
DOC_TYPE_CODE,
DOC_TYPE_NAME,
SOURCE_URL
FROM DOCV_NODE
WHERE PARENT_ID IS NULL
UNION ALL
SELECT B.PATH_LEVEL + 1 AS PATH_LEVEL,
CAST(B.FULL_PATH + '/' + A.NAME AS VARCHAR(MAX)) AS FULL_PATH,
A.NODE_ID,
A.NAME,
A.PARENT_ID,
A.CHANGE_TIME,
A.PERFORMER,
A.REPOSITORY_ID,
A.NODE_TYPE,
A.OWNER,
A.DOCUMENT_TYPE_ID,
A.CONTENT_LENGHT,
A.CONTENT_TYPE,
A.DOC_COMMENT,
A.DOC_TYPE_CODE,
A.DOC_TYPE_NAME,
A.SOURCE_URL
FROM DOCV_NODE A
INNER JOIN PATH B
ON B.NODE_ID = A.PARENT_ID)
把with path() 这里()部分去掉就Ok了