SQL Format Output

increasing column size for displaying the billcyclefullcode fully
------------------------------------------------------------------


SQL> column BILL_CYCL_FULL_CODE_N format 999999999999999999999999999

SQL> select BILL_CYCL_FULL_CODE_N from TABLENAME where trunc(cycle_start_date_d) = '01-NOV-2008' and rownum <10;