We use light weight Oracle SQL Developer with vpn client tunneling for formatting output in excel or csv files to generate reports from remote database machines.
We are using-
SQL Developer version: 1.1.2.25
Build MAIN: 25.79
For Linux x86 machine
I was working with a query result and got an error "ORA-00918: column ambiguously defined" while exporting data to excel (XLS) file.
The query, in it's simplest form was-
SELECT p.name as name, p.phone as phone, p.emerg1_name as emergency_name, p.emerg1_telno as phone
FROM provider p;
This query executed fine in SQL Developer but after getting the result, when I wanted to export the result, it showed error!
The problem is - if two output columns have same aliases (in my case, 2 phone column), the export mechanism could not distinguish the columns. I found some confusing discussions on OTN - nobody pointed out the main reason!
http://forums.oracle.com/forums/thread.jspa?messageID=1206736�
No comments:
Post a Comment