Define a variable in Oracle #DEFINE formatt = 'FM9999999999999999999990.00' select to_char(10000, '&formatt') as amount from DUAL