Query Table Name

From: <artmerar_at_gmail.com>
Date: Mon, 3 Nov 2008 12:55:36 -0800 (PST)
Message-ID: <e1afc6c4-7bd6-493a-bac5-179f773a0c15@a3g2000prm.googlegroups.com>

If you are joining one or more tables, is there a way to know which table the value came from? For example:

DECODE(<table_name>,value,<table_name>,value,<table_name>,value)........ FROM a, b, c
WHERE a.id = b.id

    AND a.id = c.id;

In this same query, can I get the table name the name of the table the value actually came from? Received on Mon Nov 03 2008 - 14:55:36 CST

Original text of this message