Re: Oracle/Pro C question
From: Scott James <saj_at_evolving.com>
Date: Wed, 27 Apr 1994 18:41:51 GMT
Message-ID: <1994Apr27.184151.61357_at_evolving.com>
Date: Wed, 27 Apr 1994 18:41:51 GMT
Message-ID: <1994Apr27.184151.61357_at_evolving.com>
Scott T Johnson (sarek_at_cais.com) wrote:
: In article <1994Apr25.223006.3514_at_venice.sedd.trw.com>,
: Harish Nachnani <nachnani_at_venice.sedd.trw.com> wrote:
: >
: >
: >THe following statement fails
: >
: > ALTER TABLE emp ADD (_d CHAR(1));
: >
: >is "_d" an invalid table name?. Does oracle flag "_" as an error if used as a part of table name.
: >
: >thanks
: >
: I believe that the '_' character is a single character wildcard
: in Oracle. Page 4-10, SQL Language Reference Manual, Oracle 6.
: Scott
That's right, _ is a wildcard. You can escape an expression by using double quotes. Try:
ALTER TABLE emp ADD ("_d" CHAR(1));
have fun!
scott
Received on Wed Apr 27 1994 - 20:41:51 CEST