Such as table query results
The name
Zhang SAN
Li si
Fifty
Become
Tom, dick and harry fifty
Inserted into a temporary table

The query other outcomes, such as
Score
80
90
100
Into a 80-90 100
Inserted into a temporary table
In the name of the corresponding shown below
Tom, dick and harry fifty
80 90 100

I don't know the name, score as the dynamic of how many a

CodePudding user response:

What is the raw data?

CodePudding user response:

A big topic ideas
Within the cursor distinct name, and then joining together into decode (name, 'zhang') such a statement, dynamic query execution,

CodePudding user response:

The original data zhang
80
Li si
90
Fifty
100