Re: create table issue

My apologies, the second example is not correct.

Errata:

In the example below, I assumed that TEST is a reserved word. It is not. I omitted to check that. Please substitute TEST in the second example with an existing reserved word, eg. INSERT. That will make the example correct.

Best regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

> Now your example
>
> CREATE TABLE "TEST"(SR INTEGER);
>
> The tokens are:
> CREATE
> TABLE
> STRING "TEST"
> BRACE_OPEN
> STRING "SR"
> INTEGER
> BRACE_CLOSE
> SEMICOLON
>
> Normally, if "TEST" wouldn't have been enclosed the lexical analyzer
> will hand over the representation for the token TEST to the parser. The
> effect of enclosing TEST in quotes will be that the lexical analyzer
> sees the token STRING, with a value of "TEST". This is OK for the
> parser, and it will enter that string as a table name in the data
> dictionary.

--
http://www.freelists.org/webpage/oracle-l