I have the following query, it is working just fine using iSQL on an Oracle 10gR2 server but not working on the SQLPLUS Oracle 10gR2 server (Two different machines).
FROM RIVET.TBL_TERMINAL TERM
JOIN RIVET.TBL_TERMINAL_TO_WAVEFORM TERM_WF ON TERM_WF.TERMINAL_ID = TERM.TERMINAL_ID
JOIN RIVET.TBL_WAVEFORM_STANDARD WF ON WF.WAVEFORM_STANDARD_ID = TERM_WF.WAVEFORM_STANDARD_ID ORDER BY TERMINAL_NOMENCLATURE;
The reason it does not work is FUNDING_STATUS is in both the TBL_TERMINAL and TBL_WAVEFORM_STANDARD (And it shouldn't work unless I use TERM.FUNDING_STATUS)
The question I have is why is it working in the iSQL when it shouldn't?
in iSQL no error at all, I get Fully Funded.
In SqlPlus I get an error saying FUNDING_STATUS - ORA-00918: column ambiguously defined
, which it is.
I'm just wondering why it works on one server and not the other, when it shouldn't work on either.
Edited by: user13015155 on Apr 19, 2012 11:08 AM
in isql plus you will get the column names as funding_status and funding_status_1 while retrieiving results. isql plus have feature of handling multiple column and internally change the column name with _1, _2 sequentially where as sqlplus doesnt have the ability