OraFAQ Forum: SQL & PL/SQL » Change Precisssion

Home » SQL & PL/SQL » SQL & PL/SQL » Change Precisssion

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Change Precisssion [message #270824]

Fri, 28 September 2007 01:52

ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka

Member

Hi,
I have a small doubt can you help

The data in a column have values like
-2021978521
-2021424827
-2021130886
The difference between two values are very less.
But when i take the ouput of the column.I get like
-2.021E+09
-2.021E+09
As a result i am not able to select distinct values.
Can you let me know how to change the output precission to
-2021978521 from -2.013E+09 in simple select statement

Thanks
Ram

Report message to a moderator

Re: Change Precisssion [message #270827 is a reply to message #270824]

Fri, 28 September 2007 01:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You have a data presentation problem NOT a data storage problem.
SQL> column DATA_VALUE format 999999999999999999999

Report message to a moderator

Re: Change Precisssion [message #270833 is a reply to message #270824]

Fri, 28 September 2007 02:24

ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka

Member

Tried the above command but still gives result in exponential form

Report message to a moderator

Re: Change Precisssion [message #270840 is a reply to message #270833]

Fri, 28 September 2007 02:37

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Does it?

SQL> create table test (data_value number);

Table created.

SQL> insert into test values (-2021978521);

1 row created.

SQL> select * From test;

DATA_VALUE
----------
-2.022E+09

SQL> column data_value format 99999999999999999999
SQL> select * From test;

           DATA_VALUE
---------------------
          -2021978521

SQL>

Copy-paste your SQL*Plus session so that we could see it.

Report message to a moderator

Re: Change Precisssion [message #270842 is a reply to message #270833]

Fri, 28 September 2007 02:42

Frank
Messages: 7901
Registered: March 2000

Senior Member

ram_ocp wrote on Fri, 28 September 2007 09:24

Tried the above command but still gives result in exponential form

replace DATA_VALUE with your column name (or the alias you use in the query)

Report message to a moderator

Re: Change Precisssion [message #270866 is a reply to message #270824]

Fri, 28 September 2007 03:52

ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka

Member

SQL> column mxid format 999999999999999999999
SQL> select distinct mxid from mxattr ;

MXID
----------
-2.009E+09
-2.009E+09
-2.009E+09

Report message to a moderator

Re: Change Precisssion [message #270869 is a reply to message #270866]

Fri, 28 September 2007 03:57

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

desc mxattr

Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.

Regards
Michel

Report message to a moderator

Re: Change Precisssion [message #270874 is a reply to message #270869]

Fri, 28 September 2007 04:07

ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka

Member

Thanks here is the formatted output

SQL> desc  mxattrtype ;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------

 MXNAME                                             VARCHAR2(128)
 MXID                                      NOT NULL NUMBER(38)
 MXFLAGS                                            NUMBER(38)
 MXPARENT                                           NUMBER(38)
 MXTYPE                                             NUMBER(38)
 MXDEFAULT                                          VARCHAR2(255)

[Updated on: Fri, 28 September 2007 04:17]

Report message to a moderator

Re: Change Precisssion [message #270876 is a reply to message #270874]

Fri, 28 September 2007 04:10

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Is there any other alternative ?

To format? yes, read the guide.

Regards
Michel

Report message to a moderator

Previous Topic:	Select Query with date comparison
Next Topic:	Regarding mutating error on a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 10 02:07:34 CST 2024