I have address column in table which contains full address like "234 hehe road" . what i like to do is i want to split this full adress and put on to another new table that i have created with road number and road name. so my next table will fill with 234 on road no, and hehe road on road name filed
I hv tried SUBSTR and INSTR function but when i worked on large rows more than 300 rows it creates problem
Could u please help me!
and i want to remove unwanted character like "?" "#" from address field too, can i use REPLACE function.