Print Thread
Displaying numbers in SQL window results
#18484 05/11/05 02:03 PM
Joined: Jul 2004
Posts: 148
Germany
B
Member
OP Offline
Member
B
Joined: Jul 2004
Posts: 148
Germany
create table test (a number);
insert into test values (1/7);
commit;
select a,to_char(a) from test

How can I change PL/SQL Developer to show the full precision? I know there is a "TO_CHAR" option, but I don't want to lose the NUMBER type (right aligned, formatted).

Re: Displaying numbers in SQL window results
#18485 05/11/05 09:40 PM
Joined: Aug 1999
Posts: 22,624
Member
Offline
Member
Joined: Aug 1999
Posts: 22,624
This is only possible with the "Number fields to_char" option.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.019s Queries: 13 (0.006s) Memory: 2.4966 MB (Peak: 3.0399 MB) Data Comp: Off Server Time: 2025-04-30 00:18:58 UTC
Valid HTML 5 and Valid CSS