Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,435 views