Home > database >  Column turned
Column turned

Time:09-20

15352034794, 501090164023,
15379108316, 501090164023,
18193262634, 501090164023,
Show a 501090164023, 15352034794, 15379108316, 18193262634

CodePudding user response:

Listagg the function, is in accordance with your demand,

CodePudding user response:

Problem description is not clear, add now, do not show all use inside a column number separated string, respectively shows into separate four columns,


Serv_id acc_nbr1 acc_nbr2 acc_nbr3
501090164023 15352034794 15379108316 18193262634

CodePudding user response:

Only these three data? Or is likely to have more than three?

CodePudding user response:

This is just a example,

CodePudding user response:

Incomplete, for example, can write N kind of result error correct answer, want to correct a result, the first to think of examples of good,
  • Related