Conversion functions
Conversion function 1.Number functions note: - no of 9’s should be equal to given number Ø Select to_char (1234,’9999D99’) from dual; it results as 1234.00 Ø Select to_char (1234,’9.9EEEE’) from dual; it results as 1.2E+03, means scientific notation form of 1234 Ø Select to_char (1234,’9G999’) from dual; it results 1,234 Ø Select to_char (1234,’L9999’) from dual; it results $1234, means local currency Ø Select to_char (-1234,’9999MI’) from dual; it results 1234-, displays ‘– ‘symbol last position Ø Select to_char (-1234,’9999PR’) from dual; it results <1234>, displays -ve no between ‘<>’ Ø Select to_char (10,’RN’), to_char (10,’rn’) from dual; it results X, x , means roman indicator of given number Ø Select to_char (10,’S99’), to_char(-10,’S99’), to_char (10,’99S’), to_char(-10,’99S’) from dual; it results +10, -10, 10+, 10- , means sign indicator Ø Select to_char (10,’XX’) from dual; i...