Hello All,
I am running this below query and getting results as expected, with one small glitch, that I want the info in the same line instead of duplicating the row:
| SQL |
|---|
select distinct (substr(target_name, 1, instr(target_name, '_') -1)) DB_NAME, (case when value = 'TRUE' then ' <-- db is not configured for Huge Pages.' end) as "Huge Page Status", value from sysman.mgmt$db_init_params where (name like '%use_large%' or name like '%sga_max%') and isdefault='TRUE' and value > '32212254720' order by DB_NAME; |
Current Output:
| DB_NAME | Huge Page Status | Value |
|---|
DB1 DB1 DB2 DB2 DB3 DB3 | <-- db is not configured for Huge Pages. <-- db is not configured for Huge Pages. <-- db is not configured for Huge Pages. | 35 45 45 |
Desired Output:
| DB_NAME | Huge Page Status | Value |
|---|
DB1 DB2 DB3 | <-- db is not configured for Huge Pages. <-- db is not configured for Huge Pages. <-- db is not configured for Huge Pages. | 35 45 45 |
What do I need to tweak in my query to duplication of rows from my output?
Much appreciate your help.
Thanks in advance,
aBBy