On Aug 13, 9:49 am, dean <deanbrow..._at_yahoo.com> wrote:
> 10g.
>
> How can one tell which table a field in a query comes from? For
> example a join between tables A and B contains 10 fields (F1 to F10),
> 5 from A and 5 from B. How would one tell if field F1 is from A or B?
> Is there a SQL-parsing system view?
One would tell if *column* F1 (databases don't have 'fields') comes
from A or B, by their alias.
This also speeds up parsing.
Other than that there is dba|all|user_tab_columns,
and there is the view DICT with a complete description of all
dictionary views, making questions like this one redundant.
But I take it you can't be bothered to read any manual.
--
Sybrand Bakker
Senior Oracle DBA
Received on Mon Aug 13 2007 - 02:57:17 CDT
