Skip to Main Content
Forums

SQL & PL/SQL

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!

Hex constants in insert statements for Number datatypes

265567May 8 2002
Is there any way to specify Hexidecimal constants for initializing Number data types? Something like this?


INSERT INTO MyTable (MyNumber9Column) VALUES(0x11000 ); -- won't work

I realize that Raw datatypes can store hex values, but we would like to store them in Number datatypes due to legacy code.

Thanks,

-R
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2002
Added on May 8 2002
1 comment
489 views