Transfer: http://space.itpub.net/21213917/viewspace-607671
ORA-00947: Not enough values
This error occurred while performing the INSERT.
Insert into table 1 values (123,2423,12);
The structure of Table 1 has four columns, and obviously only three values are inserted, so this problem arises.
After the value of the column is added, OK.
If you want to insert only three values:
Insert into table 1(a,b,c) values (123,2423,12);
Just use this statement.
ORA-00947: Not enough values
This error occurred while performing the INSERT.
Insert into table 1 values (123,2423,12);
The structure of Table 1 has four columns, and obviously only three values are inserted, so this problem arises.
After the value of the column is added, OK.
If you want to insert only three values:
Insert into table 1(a,b,c) values (123,2423,12);
Just use this statement.
Read More:
- Android：More than one file was found with OS independent path ‘res/values/values.xml
- Python3-ValueError:not enough values to unpack (expected 2, got 0)
- yaml.scanner.ScannerError: mapping values are not allowed here
- ValueError: not enough values to unpack (expected 6, got 1)
- ValueError: not enough values to unpack (expected 2, got 0)
- Error: improvement of not enough values to unpack (expected 2, got 1)
- Docker encountered a problem 4: yaml: Line 1: mapping values are not allowed in this context
- Error occurred when Python called cv2.findcontours: valueerror: not enough values to unpack (expected 3, got 2)
- Pandas sort according to a column_ values）
- VBA error values in Excel
- ValueError: need more than 0 values to unpack
- ValueError: too many values to unpack
- C++ —Return multiple values of different types
- Linux getsockopt SO_ERROR values (errno.h)
- Error in cov.wt(z) : ‘x’ must contain finite values only
- valueError: Length mismatch: Expected axis has 40 elements, new values have 38 elements
- JQuery: How to get the selected values of checkbox, radio and select
- [solution] Python flash database migrate error type error: option values must be strings
- Complex warning: casting complex values to real discards the imaginary part
- Python common error: if using all scalar values, you must pass an index (four solutions)