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>


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

Original text of this message