command window column format

[g_lagaffe]

Hi,
I have some difficulties with column formats in the command window e.g. take the following table definition:

Name Type Nullable Default Comments
------- ------ -------- ------- --------
NUM NUMBER Y
LONGNUM NUMBER Y

and execute the following statement to insert a row
insert into Testtable values(1.123456,9.987658);

When selecting the table I get the following result:
NUM LONGNUM
--- -------
1,1 9,98765

It seems that the result gets formatted according to the column length, because when I set heading off, I get appropriate results:
1,123456 9,987658

I tried to solve the problem with column formatting e.g.
COL NUM FORMAT N9,6
but column formatting does not seem to have any influence on the output!

Since I'm working a lot within the command window I would appreciate any hints.

Thanks and regards

 

[ScottMattes]

What happens when you do the same query from the SQL window?

Since finding tools that have SQL windows and grids to display the query output I have pretty much given up on using Command windows (SQLPlus, etc).

 

[Marco Kalter]

This is indeed not correct. The Command Window should have displayed the full precision. We'll fix it.