Oracle row-to-column practices

In Oracle 11g, Oracle added 2 queries: Pivot (row to column) and Unpivot (column change)

Pivot (aggregate function for column name in (type)), where in (") you can specify an alias, in, you can also specify a subquery

Row to column:

SELECT * from Rhsa_gcfx_result ORDER by Org_id,item,dictname

Select Org_id,item,sum (value) from Rhsa_gcfx_result where dictname = ' admission pathway ' and 1=1 Group by item,org_id ORDER by Org_id,i Tem

Convert Item columns to rows

SELECT * FROM (select Org_id,item,sum (value) value from Rhsa_gcfx_result where dictname = ' admission pathway ' and 1=1 GROUP by item,org _ID)
Pivot (sum (value) for item in (' 1. Emergency ' emergency ', ' 2. Outpatient ' Outpatient, ' 3. Other medical institutions transferred to ' other medical institutions ' transfer, ' 9. Other ')

Oracle row-to-column practices