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!

How to display the title of a group

syed haiderJun 12 2018 — edited Jun 12 2018

I have the following records in a table.

Create table xyz

(fruits    varchar2(50))

xyz

Apples                                   10

Oranges                                 11

Bananas                                   8

Vege

Group(peas, squash, potato)     20

Vege is the heading of the Group(peas, squash, potato).  I'm linking this table with another table that has everything except for Vege. I'm obtaining the following output.

Apples                                 

Oranges                              

Bananas                                

Group(peas, squash, potato)   

Whereas, I want to see the output as below;

Apples                                 

Oranges                              

Bananas    

Vege                          

Group(peas, squash, potato)   

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2018
Added on Jun 12 2018
#group, #oracle, #sql
2 comments
212 views