select lpad(' ',2*(level-1)) || to_char(t.kod) s from deneme t where t.deger='abc' START WITH t.ust_id='0' CONNECT BY PRIOR t.kod = t.ust_id
ref : http://renenyffenegger.ch/notes/development/databases/Oracle/SQL/select/hierarchical-queries/start-with_connect-by/recursive-additions
- Üyelik 25.06.2012
- Yaş/Cinsiyet 38 / E
- Meslek Engineering Director
- Konum İstanbul Avrupa
- Ad Soyad T** C**
- Mesajlar 771
- Beğeniler 2 / 260
- Ticaret 0, (%0)