- SQL> select id,userid from tbluseraccount where rownum<=2 ;
- ID USERID
- ---------- ----------
- 1.0000E+15 1.0000E+15
- 1.0000E+15 1.0000E+15
- ----sqlplus解决办法
- show numwidth
- numwidth 10
- set numwidth 20
- ---to_char
- select to_char(id),to_char(userid) from tbluseraccount where rownum<=2 ;
转载于:https://blog.51cto.com/ocpyang/1195760