Recipe 6.10. Creating a Delimited List from Table Rows
SELECT LPAD(' ', 1*level-1)||SYS_CONNECT_BY_PATH(ename, '/') "Path"
FROM emp
START WITH ename = 'SCOTT'
CONNECT BY PRIOR empno = mgr;
FROM emp
START WITH ename = 'SCOTT'
CONNECT BY PRIOR empno = mgr;
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23895263/viewspace-681605/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Recipe 4.10. Updating with Values from Another Table
- Script: To remove Chained Rows from a Table (Doc ID 1019556.6)REMAI
- Bug 9369183 - ORA-32349 creating MView on prebuilt table using select from remote tableViewUIREM
- Recipe 6.7. Extracting Initials from a Name
- Recipe 5.2. Listing a Table's Columns
- Creating External Lists From Code
- Creating a physical standby from ASM primaryASM
- Remove Duplicates from Sorted ListREM
- Remove-duplicates-from-sorted-listREM
- Creating a physical standby from ASM primary [ID 787793.1]ASM
- 83. Remove Duplicates from Sorted ListREM
- Creating a Physical Standby using RMAN DUPLICATE FROM ACTIVE DATABASEDatabase
- Could not execute Write_rows event on table time_task.tt_log
- 【RAC,DATAGUARD】Creating a physical standby from ASM (RAC ) primary之四ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之三ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary 之二ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之一ASM
- 19. Remove Nth Node From End of ListREM
- Leetcode Remove Duplicates from Sorted ListLeetCodeREM
- 82. Remove Duplicates from Sorted List IIREM
- Leetcode Remove Duplicates from Sorted List IILeetCodeREM
- Leetcode Remove Nth Node From End of ListLeetCodeREM
- Leetcode-Remove Duplicates from Sorted ListLeetCodeREM
- Remove Duplicates from Sorted List leetcode javaREMLeetCodeJava
- GoldenGate "Error mapping from table.a to table.a"錯誤測試GoErrorAPP
- js的table表格物件的rows屬性用法簡單介紹JS物件
- Leetcode 19 Remove Nth Node From End of ListLeetCodeREM
- LeetCode 83. Remove Duplicates from Sorted ListLeetCodeREM
- 【Leetcode】83. Remove Duplicates from Sorted ListLeetCodeREM
- Leetcode-Remove Duplicates from Sorted List IILeetCodeREM
- Leetcode-Remove Nth Node From End of ListLeetCodeREM
- Remove Duplicates from Sorted List II leetcode javaREMLeetCodeJava
- Remove Nth Node From End of List leetcode javaREMLeetCodeJava
- java 中 set map table list ~~的總結Java
- You can‘t specify target table ‘Person‘ for update in FROM clause
- Oracle模擬MySQL的show index from table命令OracleMySqlIndex
- 關於 mysql 中的 select * from table_a,table_b 的問題MySql
- on commit delete rows and on commit preserve rowsMITdelete