Re: Static Select statements
Date: Fri, 04 Apr 2008 00:28:19 +0200
On Mon, 31 Mar 2008 05:03:21 -0400, Ubiquitous <weberm_at_polaris.net> wrote:
>>On Mar 28, 3:19 pm, Ubiquitous <web..._at_polaris.net> wrote:
>>> Is there a way to force a static row in a SELECT statement?
>>> For example, I have a SELECT statement which is a UNION of two identical
>>> tables, "A" and "B". How would one create a column which identifies the
>>> source table?
>>> TABLE NAME REC#
>>> ----- ---- ----
>>> A Bob 001
>>> A Tim 002
>>> B Joe 001
>>> A Sue 003
>>This should work:
>>Select 'A' as 'TABLE', name, recno
>>select 'B' as 'TABLE', name, recno
>Thank you! That's exactly what I was seeking!
>The 'TABLE' literal should be enclosed with double quoyes ("), however.
Senior Oracle DBA Received on Thu Apr 03 2008 - 17:28:19 CDT