If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

SQL Error: ORA-01438: value larger than specified precision allowed for this column
01438. 00000 - "value larger than specified precision allowed for this column"
*Cause: When inserting or updating records, a numeric value was entered
that exceeded the precision defined for the column.
*Action: Enter a value that complies with the numeric column's precision,
or use the MODIFY option with the ALTER TABLE command to expand
the precision.

You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.

You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.

none of the INSERTED rows began with "[" character.
SQL does not default to use REGEX expressions

You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.

How would i best phrase it if there are multiple characters in the string such as
CONSTRAINT Sale_Rego_ck CHECK(Rego LIKE '[0-9][0-9][0-9][A-Z][A-Z][A-Z]')

Maybe, instead of guessing syntax of condition allowing regular expression, you should search it in the documentation. It is available e.g. online on http://tahiti.oracle.com/
From 10gR1, Oracle uses REXEXP_LIKE condition for treating regular expression patterns.

Just curious: shall INSURENCEID really contain three digits followed by three leteters in uppercase without anything among them? Quite impossible for one letter long string.
What is wrong with anacedent's constraint?

slow learner?
unwilling or incapable to Read The Fine Manual yourself on REGEXP_LIKE

>[0-9][0-9][0-9][A-Z][A-Z][A-Z]
Must the leftmost all 3 places contain digits?
Must the rightmost all 3 places contain CAPITAL letters?
Are any blank/space "CHR(32)" characters allowed anywhere?
is "1A" valid content?

You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.

>[0-9][0-9][0-9][A-Z][A-Z][A-Z]
Must the leftmost all 3 places contain digits? yes
Must the rightmost all 3 places contain CAPITAL letters? yes
Are any blank/space "CHR(32)" characters allowed anywhere? no
is "1A" valid content? No needs to be six characters long

and i have readREGEXP_LIKE
but still couldn't quite understand how to do what i'm trying to do.