As shown in figure, in baidu search, were quite complicated sentence translation,
But I'm not a database administrator, just sometimes need a query in work at ordinary times, and there is no specific interface,
Query to the record is not much, but often is the records show that so many content, horizontally very inconvenient, even setting linesize looked at one, so the longitudinal display will be very convenient intuitive,
I am now in use SqlDbx this tool, is there anyone which tools with display conversion function?

CodePudding user response:

The building Lord baidu once turn "line column"

CodePudding user response:

Export to excel, the query results in excel selection, paste special "transpose

CodePudding user response:

Wm_concat try?

CodePudding user response:

 unpivot turn line (column) or use union all 

CodePudding user response:

You this bad oracle direct unpivot and pivot are not enough,
Try the direct use excel to turn to