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_at_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 - 23:59:23 CET

This message: [ Message body ]
Next message: Vince: "Problem with some SQL queries"
Previous message: sybrandb_at_yahoo.com: "Re: scheduling a PL/SQL proc / function"
In reply to: Niy: "column name can't include character '-'"
Next in thread: x: "Re: column name can't include character '-'"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message