is there any functions in Oracle where I can filter the data out. For example, if I have the data in 1 column and there are lot of crap in there let say:
1800,
210a,
202b,
2000
Is there a function for me to pick only the number data??? Anything else we can trash
thanks