Query for updating a node in a hierarchial tree structure my own dating site

Posted by / 20-Oct-2019 21:59

Query for updating a node in a hierarchial tree structure

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 9.2.0.1.0 - Production on Wed Aug 4 2004Copyright (c) 1982, 2002, Oracle Corporation. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production select empno, 2 lpad( '_', 2 * ( level - 1 ), '_' ) query for updating a node in a hierarchial tree structure-69query for updating a node in a hierarchial tree structure-67query for updating a node in a hierarchial tree structure-14

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.