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 add category for respective variable

CostaNov 20 2020

Hi All,
From the below master table, I need to add category and sub-category for few variable like below
e.g Add category Fitness1 to exercise, diet and Running like below table. I tried all possible way but can not proceed whether I should split whole table into three child table and then create relation. can you please guide
image.png
image.png

Comments

thatJeffSmith-Oracle

it is being auto-adjusted...the true content is all that html, it's only that the GREEN is the only text being rendered
So in your query, easy to fix, adjust to column name width

User_AOUZ4

Hi Jeff,
Understood that rendering is causing the column width to be longer than expected.
how to adjust column name width . do you mean instead of column name "STATUS"
we should use "=============STATUS=============" or something like that ?

thatJeffSmith-Oracle
Answer

right click on headers, autofit on the header

Marked as Answer by User_AOUZ4 · Nov 24 2021
1 - 3

Post Details

Added on Nov 20 2020
#mysql
3 comments
457 views