asked on
Sql query displays multiple records on a single line.
Trying to create a sql query that takes records from a table and displays the records on one line as shown in example below.
| ID | IDENT | IDENT_ID | TYPE | CITY | STATE |
| 19Young | URDA | 1234 | USR | Chicago | IL |
| 19Young | URDA | 4321 | MODE | Chicago | IL |
| ID | IDENT | IDENT_ID TYPE | CITY | STATE | |
| 19Young;19Young | URDA;URDA | 1234;4321 | USR;MODE | Chicago;Chicago | IL;IL |
SQLOracle Database
Last Comment
slightwv (䄆 Netminder)
Which specific version of SQL are you on? SQL 2016 or later? Or earlier than SQL 2016?
ASKER
Oracle 19 db. The starting table is a Temp table that I've inserted data in to make this task easier. The final solution will be a pl/sql procedure. I guess when implemented with real data it could be more than 2 records in the temp table.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I thought there might be a query that could make this easier. Otherwise my plan is to write a plsql procedure that loops though the number of records and use a couple temp tables to place to data in a results table as specified.
>>and use a couple temp tables to place to data in a results table as specified
Words of advice:
As SOON as that idea pops into your head, IMMEDIATELY think: NO!!!!!
Sure, over the years I have used them myself. BUT only in very rare instances and I knew what I was doing.
Way to often in life when I've come across them, they were 100% unnecessary and were slower than native SQL.
Words of advice:
As SOON as that idea pops into your head, IMMEDIATELY think: NO!!!!!
Sure, over the years I have used them myself. BUT only in very rare instances and I knew what I was doing.
Way to often in life when I've come across them, they were 100% unnecessary and were slower than native SQL.
»bp