Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00406: length of SELECT list in subquery must match
number of assignment targets
- 1 Answers
- 3103 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: A query select list is not the same length as the
list of targets that will receive the returned values. For
example, the following statement is faulty because the
subquery returns two values for one target: UPDATE emp SET
ename = (SELECT ename, empno FROM emp WHERE ename = 'SMITH') ...
Action: Change one of the lists so that they contain the
same number of items.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-13628: Insufficient privileges to access the task belonging to user string
KUP-04071: record discarded from file string
KUP-04075: no read access to directory object string
ORA-29367: object string does not exist
TNS-12696: Double Encryption Turned On, login disallowed
RMAN-06740: database name is not specified
SQL*Loader-00422: constant element count of number for column string is greater than maximum, number
ORA-00055: maximum number of DML locks exceeded
ORA-14169: invalid ALTER TABLE MODIFY SUBPARTITION option
ORA-12434: invalid audit type: string
NNL-01007: VERSION SKEW responses received: number
ORA-07225: sldext: translation error, unable to expand file name.
Oracle Errors 
