Normalizing database
Hello, community ! I'am new here, so as in sql (started to learn)
So, i got really nasty table with fields containing comma seperated values, for example:
Field name - ID: 1
Field name - Name: 'Thing1, Thing2, Thing3, Thing4'
somehow, i need to relate that to other table and my desired table should look like that :
Somethings_ID1:
Thing1
Thing2
Somethings_ID2:
Thing1
Thing3
Something_ID3
Thing1
Thing2
Thing3
How should i seperate all comma related strings and relate them with other's table id's, even if they repeating. Thanks ! Hoping my question is clear :))
Subject
Written By
Posted
Normalizing database
May 20, 2022 12:50PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.