Re: column name can't include character '-'

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 18 Feb 2004 17:59:23 -0500
Message-ID: <acudnT9l6tESc67dRVn-ig@comcast.com>

"Niy" <niy38_at_hotmail.com> wrote in message news:55dd405a.0402181456.5904258c_at_posting.google.com... | why?

that's the rules

also, '-' has special meaning to the parser

however, just like Access and VB use [] delimiters, Oracle (and I believe this is standard ANSI SQL) uses "" delimiters to allow 'illegal' column (and other object) names -- but I wouldn't recommend this

just use _ instead of -, and life with oracle will be just fine

;-{) mcs Received on Wed Feb 18 2004 - 16:59:23 CST