求救.屏蔽烦人的科学计数法!!!!!!

[sky1026]

select * from t_rc_detail_temp where rownum<10;

RC_SEQ ACCOUNT_ID
------------------- -------------------
2963788 5.31E17
3536691 5.31E17
2620121 5.31E17
4748050 5.31E17
1432115 5.31000000003511E17
4188193 5.31000000003511E17
2093734 5.3100000000788E17
2093735 5.3100000000788E17
2924329 5.3100000000788E17

怎么样才能让它正常显示.ACCOUNT_ID;(除了用to_char,这样不能看全部数据!)

[沝林]

SQL> select 12321431434324324324324324324 a from dual;

A
----------
1.2321E+28

SQL> colu a form 99999999999999999999999999999999999;
SQL> select 12321431434324324324324324324 a from dual;

A
------------------------------------
12321431434324324324324324324