ora 01438 value larger than

Ora-01438:value larger than specified precision for this column When the eye is clear, the field length is not enough. INSERT INTO OSS_ADDR_MON_STATS_TMP06Select/*+use_hash (a,c) * *Provcode,AreaCode,Count (A.serialid) as

There are 4 main levels of setting Errorstack:0 Dump Error stack only (level 0 has been deprecated)1 Dump the error stack and the function call stack2 Level 1 + processstate3 level 2 + Context area (show all cursors, highlighting current

ORA-01438 Processing MethodSolution: (1) Track and execute the inserted SQL/stored procedure, locate the row that causes the culprit, and insert the row again after modification. (2) The simplest way is to increase the precision of the target field.

Solution: (1) Track and execute the inserted SQL/stored procedure, find the row that causes the culprit, and insert the row again after modification. (2) The simplest way is to increase the precision of the target field.   Because the specific table

Problems encountered in the experiment: 1. At the beginning of the experiment, resetlogs reset the online log, resulting in misslogfile errors always reported during the flash. In this case, you need to use the noretlogs method to recreate the

 oracle   number  type precision, scale range   Number (p,s) P:1---38 S: -84---127 valid digits   : From the left of the first number not  0 , to the end of all numbers, the decimal point and minus sign are not counted in the number of

Problems encountered in the experiment:1, just beginning to do the previous experiment, resetlogs reset the online log, resulting in flash back when always reported miss logfile error.This time you need to rebuild the control file in a noretlogs way,

Quote: http://www.blogjava.net/caojianhua/archive/2011/01/24/343461.html Oracle's number type is one of Oracle's built-in types and is the most basic numeric data type for Oracle. Only one intrinsic data type suitable for storing numeric data was

In Oracle 10g, data is passed between two databases through triggers, but the following error is always thrown in the program: Ora-01438:value larger than specified precision for this column Tip A column of precision, but no hint is that column,

The number data type is widely used in Oracle. It can store zero-value, positive-negative, and fixed-length data. There are several concepts for this data type to be clarified, otherwise it is easy to confuse, the following is a detailed description.