I would like to convert values from column TEXT
ID TEXT
182234 ZO-Z-000-4OB-566WD1#ZO-Z-000-4OB-566WD#ZO-Z-000-4OB-566WD2#
182245 ZO-Z-000-4OB-567WD1#ZO-Z-000-4OB-567WD#
into separate rows (something like this, # will be delimiter)
ID TEXT
182234 ZO-Z-000-4OB-566WD1#
182234 ZO-Z-000-4OB-566WD#
182234 ZO-Z-000-4OB-566WD2#
182245 ZO-Z-000-4OB-567WD1#
182245 ZO-Z-000-4OB-567WD#
Oracle Database 18c