Not sure I understand what you mean. You can have a table called employee
with a column called emp_id and you can have another table called address
which also has a column called emp_id. Not an unusual thing at all. If
Powerbuilder does not like that (I am not real familiar with Powerbuilder)
you should be able to build a view of one of the tables and rename the
column in the view:
create or replace view employee2 as select emp_id empl_emp_id from employee;
If Powerbuilder requires globally unique column names (that seems like an
unusual requirement)
Jim
Doug Stone wrote in message <74bnn1$ogu_at_dfw-ixnews10.ix.netcom.com>...
>Hi. I have to implement, in Oracle, a db that includes duplicate column
>names.
>
>For instance, emp_id is in the employee table, and in the address table.
>
>The application was build with PowerBuilder datawindows.
>
>If I setup correct RI between all the duplicate column names, the
>datawindows will fail.
>
>Does anyone know how I can, temporarily, disable Oracle insistence on
unique
>column names?
>
>Thank you,
>Doug
>
>
Received on Sat Dec 05 1998 - 12:46:35 CST
