LoginSignup
2
2

More than 5 years have passed since last update.

@0829

sqlplusにて桁数が指数表示されてしまう

Last updated at Posted at 2013-02-15

出力フォーマットを個別に指定する。

COLUMN SUM(COL) FORMAT 999999999999999999

あるいはまとめてNUMBER型の表示幅を指定する。

SET NUMWIDTH 15
2
2
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
2
2