Query for updating a node in a hierarchial tree structure my own dating site
Eg Data returned as we have it now ....1A2AA3AAA4AAAA5AAAAA1A2AB3AB24AAA5ABCD1 C2 CCPerform a search for AAA, want the below returned...1A2AA3AAA1A2AB3AB24AAAIs this possible in a statement? Got any tips to share which can help visualizing solutions to a problem like this one?
Regards Deepak SELECT LPAD (' ', 2 * (LEVEL - 1))
This system resembles a tree-structure by sharing the same parent number and then branches like trees.SQL Hadn't yet encountered the SYS_CONNECT_BY_PATH function--pretty neat.How about this as a simpler alternative to the above queries: SQL*Plus: Release 184.108.40.206.0 - Production on Wed Aug 4 2004Copyright (c) 1982, 2002, Oracle Corporation. Connected to: Oracle9i Enterprise Edition Release 220.127.116.11.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 18.104.22.168.0 - Production select empno, 2 lpad( '_', 2 * ( level - 1 ), '_' )
Such linking is not possible here as a parent can have many children and not the reverse i.e. Therefore, Many-to-Many or One-to-Many data linking is not at all possible. You agree that we have no liability for any damages.