CLEAN up data
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: CLEAN up data

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    CLEAN up data

    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    To me, the best way would be to write a function. That way, you'll have total control over how you want your data to be handled.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width