Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Domain Number Strict and Precision

Mike KutzDec 23 2023 — edited Dec 24 2023

Given a domain with a number data type with a precision, how is strict expected to operate?

Given

create domain test_dom as number(4,0) strict

this, unexpectantly, passes

select domain_check_type( test_dom, '1234.56' ) as is_valid

Documents describe how varchar2 operates but not (or it isn't clear) how strict domains operates with number(length,precision) data types and an inappropriate number (too precise) is given.

it seems the string '1234.567' is first converted to 'number(4,0)' then tested for length. I was expecting it to be converted to number then the length&precision are tested to see if it fits into number(4,0)

This post has been answered by Chris Saxon-Oracle on Jan 3 2024
Jump to Answer
Comments
Post Details
Added on Dec 23 2023
8 comments
257 views