6 Replies Latest reply: Mar 29, 2013 8:20 AM by 864103 RSS

    sql

    864103
      Hi guys ,

      oracle 11g.2 under OL 5.6

      i have table with .5 million records i just import this table from another database
      and i see that the date col in varchar2(20) not date ,

      please guide me how to change it to date from varchar2(20) with data ?

      also please if i have col contain the data let's say
      123 45
      1 2345
      123 45
      i mean we have col with space in diff loc how can i update it this to remove the space ??


      thanks