Skip to Main Content

SQL & PL/SQL

TREES in table

arizioMar 10 2009 — edited Mar 11 2009
Hi all,
I need to create a select statement for this problem

TABLE T_A is
C_1_ | C_2 __| C_3 | C_4
--------------------+----------
1___ |______|____ |____
12___|_1___ |____ |____
123__|_____|_____ |_____
13___|_____|___2_|____
134__|_____|__3__|_3___
1345_|_____|____ |____
13456|_____|_____|____
19___|_____|___4_|__ 4_
191__|_____|_____|_____
1912_|__1__|_____|_____
19123|_____|___9_|_____

and must be "compressed" in

C_1__| C_2 _| C_3_| C_4
--------------------+------
123___|__1_|____ |_______
13456_|____|__3__|__3___
19123_|__1_|__9__|__4__



Is this possibile with a SELECT - INSERT statement


Thanks!
Riccardo

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2009
Added on Mar 10 2009
16 comments
1,331 views