Snippet Library
Select récursif sous Oracle | |
| Type: Sample Code (HOWTO) |
Category: Database Manipulation |
| License: GNU General Public License |
Language: SQL |
Description: Exemple de select récursif appliqué à la table structure de grhum@cocktail | |
Versions Of This Snippet:
| Snippet ID | Download Version | Date Posted | Author | Delete |
|---|---|---|---|---|
| 6 | 0.1 | 2017-01-19 18:48 | Jean-marie Kubek | 
|
Download a raw-text version of this code by clicking on “Download Version”
Latest Snippet Version: 0.1
select lpad(' ', 2*level) || ll_structure from structure_ulr start with c_structure = '21' connect by prior c_structure = c_structure_pere
Add a new version
You can submit a new version of this snippet if you have modified it and you feel it is appropriate to share with others.