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>


"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

Original text of this message