I’m not sure why you want to split it out like that, because the result you showed is much more efficient (1 record vs 3 records). The only thing is that
you have to extract out the values when you query that record, which can be done in many different ways using SQL or PL/SQL.
Here is just one example of how you would extract the info from that column. If you are using PL/SQL, then you could just set up a simple little loop.
As for why they are being concatenated like that, you would need to look at your BPM process, as it’s probably concatenating them together like that before
your writing them to a table, which is actually much more efficient than writing out every record. If you really want to split them out, then you would need to split them out before you write your insert.
From: Andersun [mailto:bounce-Andersun@toadworld.com]
Sent: Friday, October 31, 2014 3:23 AM
Subject: [Toad for Oracle - Discussion Forum] Insert multiple rows
Insert multiple rows
Thread created by Andersun
I as fresher so my question might be basic pls do respond.
How do i write a query to insert multiple rows into the table, i.e we use IBM BPM tool in front end, user can select skill set from a List of value. on submit the value should get updated in
db as follow
skill set is an array
I wrote a query like " inser into Table_Name (emp_id,Skill_set,Req_id) values ( employeeid,skillset,requestid)
Primary key is set as trigger in table.
but when i check the table all records are inserting into single row
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.