Re: PSUEUDOCOLUMN

From: <michael_bialik_at_my-deja.com>
Date: Sun, 19 Sep 1999 14:16:49 GMT
Message-ID: <7s2r8c$oid$1@nnrp1.deja.com>

Hi.

If you are using Oracle 8i - use "native dynamic sql", otherwise you must use DBMS_SQL package.

Michael.

In article <7ru878$479$1_at_bgtnsc01.worldnet.att.net>, "Jill" <jc_va_at_hotmail.com> wrote:
>
> 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun Sep 19 1999 - 09:16:49 CDT