title: how to covert string format such as Aug 17 to date in oracle
body: <p>I have a table and one of the fields is a varchar2 data type, it stores some date in a string format such as Aug 17, Sep 18 etc. I want to sort this field according to real date not alphabet, how can I convert these value to date?</p>