exhaustive, The aims of the said examples are with a minimal knowledge or recap of your oracle sql strength, we should be able to generate application software,
Apart from selective data type retrieval, there are certain functions are used for conversion of data types
14.01 How to convert date type value to char type value
1, To-char( ) Transforms a date or number into a character string, For example, sysdate generally displays date as dd-mon-yy (18-Jun-10), In case, if we want to see the date in did-mm-ivy format, we shall use the "select to_char(sysdate,'dd-mm- yyyy') as formatted_date from dual" and result
will be
Formatted-Date
- - - - - - - - - - - -
18-06-2010