ORA-00918: | column ambiguously defined |
Cause: | A column name used in a join exists in more than one table and is thus referenced ambiguously. In a join, any column name that occurs in more than one of the tables must be prefixed by its table name when referenced. The column should be referenced as TABLE.COLUMN or TABLE_ALIAS.COLUMN. For example, if tables TEST1 and TEST2 are being joined and both contain the column DEPTNO, then all references to DEPTNO should be prefixed with the table name, as in TEST1.DEPTNO or T.DEPTNO. |
Action: | Prefix references to column names that exist in multiple tables with either the table name or a table alias and a period (.), as in the examples above. |
Labels
- Apache (10)
- Articles (4)
- BPM Tools (5)
- Glassfish (16)
- Hadoop (10)
- HP ALM (6)
- HP SOA Systinet (14)
- Issues (19)
- JAVA (85)
- JBoss (16)
- jQuery (4)
- Load Runner (37)
- Quality Center (49)
- Testing (24)
- Tips and Tricks (16)
- Tomcat (4)
- Usefull Links (18)
- Weblogic (41)
- WebSphere (2)
Friday, May 25, 2012
ORA-00918: column ambiguously defined in java
Labels:
JAVA
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment