Procedure



I need help with procedure. I appreciate the help.

The table has two columns with the data is like this.

Table Name : Temp

Event_F Event_B

abc01 bvc32 nbv43 mnb54
dsf32 iou09 nmj87 lkh87 mny67

There is no , in the data of Event_B.

I need the output like this:

Event_F Event_B
abc01 bvc32
abc01 nbv32
abc01 mnb54
dsf32 iou09
dsf32 nmj87

The records are in thousands.

.