connect by和start with的原理和使用方法 先说明用在哪里吧: connect by一般用在创建数据库链接时用的 start with是用在创建sequence时用的至于用法,可以参照建链接和序列的SQL语法 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你误会了,我是说用在select 语句中的原理和使用方法以及时机句我现在的了解他们能生成树型数据 就是和group by ,order by一样的位置呀 例如: CURSOR C_COMPONENT IS SELECT COMP_QTY,COMP_ITEM,LPAD('.',LEVEL,'.')||COMP_ITEM ITEM_NAME, COMP_REV_11,COMP_REV_12,COMP_REV_13,RECORD_STATUS,CREATED_BY, CREATED_ON,UPDATED_BY,UPDATED_ON,COMP_UM,LEVEL FROM EM_ITEM_BOM START WITH (ITEM_ID=D_BOM.ITEM_ID AND COMP = D_BOM.COMP AND BCR_TYPE = D_BOM.BCR_TYPE AND ITEM_REV_11 = NVL(D_BOM.ITEM_REV_11,' ') AND ITEM_REV_12 = NVL(D_BOM.ITEM_REV_12,' ') AND ITEM_REV_13 = NVL(D_BOM.ITEM_REV_13,' ')) CONNECT BY PRIOR COMP = COMP AND PRIOR COMP_ITEM = ITEM_ID AND PRIOR BCR_TYPE = BCR_TYPE AND PRIOR COMP_REV_11 = NVL(ITEM_REV_11,' ') AND PRIOR COMP_REV_12 = NVL(ITEM_REV_12,' ') AND PRIOR COMP_REV_13 = NVL(ITEM_REV_13,' ');HQ.Wang 海清 http://expert.csdn.net/Expert/topic/1551/1551178.xml?temp=.1285059 http://expert.csdn.net/Expert/topic/1888/1888515.xml?temp=.6319696 跟帖,求大神指点 匿名块中的procedure ORA-00928: 缺失 SELECT 关键字 oracle客户端连接不上服务器上的数据库 如何将.ec文件转换成.pc oracle盲提问:如何用c连接oracle 9i for linux7.2 oracle rownum 的奇怪问题。 关于ORACLE与SQLSERVER左连接的疑问,请高手看看 请问:ORACLE中用什么类型字段保存文件。怎样插入一条记录请举个例子 Oracle sql server 连接局域网内的一个oracle数据库怎么连 如何界定大型数据库和超大型数据库的区别? 子查询
句我现在的了解他们能生成树型数据
SELECT COMP_QTY,COMP_ITEM,LPAD('.',LEVEL,'.')||COMP_ITEM ITEM_NAME,
COMP_REV_11,COMP_REV_12,COMP_REV_13,RECORD_STATUS,CREATED_BY,
CREATED_ON,UPDATED_BY,UPDATED_ON,COMP_UM,LEVEL
FROM EM_ITEM_BOM
START WITH (ITEM_ID=D_BOM.ITEM_ID
AND COMP = D_BOM.COMP
AND BCR_TYPE = D_BOM.BCR_TYPE
AND ITEM_REV_11 = NVL(D_BOM.ITEM_REV_11,' ')
AND ITEM_REV_12 = NVL(D_BOM.ITEM_REV_12,' ')
AND ITEM_REV_13 = NVL(D_BOM.ITEM_REV_13,' '))
CONNECT BY PRIOR COMP = COMP
AND PRIOR COMP_ITEM = ITEM_ID
AND PRIOR BCR_TYPE = BCR_TYPE
AND PRIOR COMP_REV_11 = NVL(ITEM_REV_11,' ')
AND PRIOR COMP_REV_12 = NVL(ITEM_REV_12,' ')
AND PRIOR COMP_REV_13 = NVL(ITEM_REV_13,' ');HQ.Wang 海清