Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg: a tilde in NUMBER field-

915396Aug 1 2013 — edited Aug 2 2013

Hi Experts,

I've a doubt regarding NUMBER field, where a tilde ~ was stored. Just want to understand how that got inserted in that column?

When I gave a DUMP of that column it shows like this [value | DUMP(value)]:

-- In SQL Developer:

Infinity | Typ=2 Len=2: ff,65

-- In another IDE (called SQL Tools and SQL*Plus):

~ | Typ=2 Len=2: ff,65

Also, I read from Oracle docs that NUMBER field can also accept values like POSTIVE INFINITY (takes 2 bytes) and NEGATIVE INFINITY (1 byte).
Any pointers regarding this?

-- Ranit

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 30 2013

Added on Aug 1 2013

#general-database-discussions

8 comments

3,674 views