


        Oracle has a number of built-in functions
        
        for example
        Please show all the order from October
        
        select *
        from customer.orders
        where extract(MONTH from order_date) = 10
        
        
        to format a number as currency, I can convert it to 
        charector and add...
        
        to_char(total_amount, 'L999G999D99')
           the 'L' says add a current symbol
           the 9 says use a number value here (leading zero suppresed)
              by keeping training zeros, so I get 2 decimal places
           the 'G' says add the thousands seperator ',' in the US
           the 'D' days add a decimal seperator '.' in the US
         
        
        select order_date, to_char(total_amount, 'L999G999D99')
        from customer.orders
         where extract(MONTH from order_date) = 10
        
