When the actual oracle value exceeds the specified length of a database field, an error is reported. oracle Length
ORA-01438: value larger than specified precision allowed for this column
The length of the actual value is greater than the maximum length allowed by a field in the database.
A common scenario is the automatic growth of oracle sequence. When the system uses it, the sequence value keeps increasing and the system starts to report an error.
Solution: Change the field length.
There is a large amount of data to be imported into the oracle database, but the length of a field in the data is too long to be imported. What should I do? Is there any good solution?
Oralce a table has a field length addition cannot exceed a certain value. If it is not enough, use text, or create several other tables for separate storage.
Oracle queries a field where the value length is not greater than 100, but the null record is gone.
Length (nvl (note, '') <100