Re: Do FROM items of different schemas conflict?

Tom Lane wrote:
> Joe Conway <mail@joeconway.com> writes:
> 
>>This works in Oracle 8.1.6
>>
> 
> So what does Oracle do with
> 
> select plan_table.operation from apps.plan_table, cyapps.plan_table;
> 
> ??
> 

SQL> select plan_table.operation from apps.plan_table, cyapps.plan_table;

select plan_table.operation from apps.plan_table, cyapps.plan_table

ORA-00918: column ambiguously defined


Joe