Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    4

    How to remove comma in column

    I want to remove one comma from my date column which looks like this :


    APRIL ,2010

    How do I remove comma and space using update statement in Oracle.



    Thanks!!!

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,008
    Using the REPLACE function, for example.

Tags for this Thread

Posting Permissions

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