spool
currently spooling to C:\WINDOWS\Desktop\huh.LST
SQL> create table test1 (f1 char(1))
2
SQL> /
Table created.
SQL> ed
Wrote file afiedt.buf
1* create table test2 (f1 char(1))
SQL> /
Table created.
SQL> ed
Wrote file afiedt.buf
1* insert into test2 values ('2')
SQL> /
1 row created.
SQL> commit;
Commit complete.
SQL> ed
Wrote file afiedt.buf
1* insert into test1 values ('1')
SQL> /
1 row created.
SQL> commit;
Commit complete.
SQL> select test1.f1, test2.f1
2 from test1, test2;
F F
- -
1 2
SQL> ed
Wrote file afiedt.buf
1 select f1, f1
2* from test1, test2
SQL> /
select f1, f1
*
ERROR at line 1:
ORA-00918: column ambiguously defined
SQL> ed
Wrote file afiedt.buf
1 select test1.f1, f1
2* from test1, test2
SQL> /
select test1.f1, f1
*
ERROR at line 1:
ORA-00918: column ambiguously defined
SQL> ed
Wrote file afiedt.buf
1 select f1, test2.f1
2* from test1, test2
SQL> /
select f1, test2.f1
*
ERROR at line 1:
ORA-00918: column ambiguously defined
SQL> drop table test1
2
SQL> /
Table dropped.
SQL> drop table test2
2
SQL> /
Table dropped.
SQL> spool off
On 27 Apr 2001, at 2:00, [EMAIL PROTECTED] wrote:
> Can I use the same column name in the same database and in the
> same schema? Could this cause me lots of trouble?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
