Re: column name can't include character '-'
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 20 Feb 2004 06:20:43 -0500
Message-ID: <r9-dnefd8qxVcKjdRVn-vA_at_comcast.com>
| In v$transaction, you can see
| DSCN-B, DSCN-W columns, how
| to select them?
Date: Fri, 20 Feb 2004 06:20:43 -0500
Message-ID: <r9-dnefd8qxVcKjdRVn-vA_at_comcast.com>
"Niy" <niy38_at_hotmail.com> wrote in message
news:55dd405a.0402191936.584f4b8e_at_posting.google.com...
| Thanks for the reply.
|
| In v$transaction, you can see
| DSCN-B, DSCN-W columns, how
| to select them?
very observant -- you have to (always) use double-quotes to select these columns, and type them in upper case, because oracle (why, oh, why?) used non-conforming column names here
the only exception to 'always' is when you do a SELECT *
select addr, "DSCN-B", "DSCN-W"
from v$transaction
;-{ mcs Received on Fri Feb 20 2004 - 12:20:43 CET