PSUEUDOCOLUMN

From: Jill <jc_va_at_hotmail.com>
Date: Fri, 17 Sep 1999 13:44:18 -0700
Message-ID: <7ru878$479$1@bgtnsc01.worldnet.att.net>

Does there exist a psuedocolumn for table name? I want to write a query as such, but don't want to have to hard-code the name in the predicate. I want to somehow replace

WHERE D.TABLE_NAME = 'MY_APP_TABLE' with

WHERE D.TABLE_NAME = B.PSUEUDOCOLUMN_FOR_ALIAS_B SELECT

 B.SSN

,D.TABLE_NAME
,D.AVG_ROW_LEN
,COUNT(*)
,COUNT(*) * D.AVG_ROW_LEN

FROM MY_APP_TABLE B
    ,DBA_TABLES D
WHERE D.TABLE_NAME = 'MY_APP_TABLE'

GROUP BY B.SSN
        ,D.TABLE_NAME
        ,D.AVG_ROW_LEN

Received on Fri Sep 17 1999 - 15:44:18 CDT