how to set 2 type of date format in to char in oracle sql code example Example: date format in oracle e.g., 01-JAN-17