Re: create table issue
- From: "Carel-Jan Engel" <cjpengel.dbalert@xxxxxxxxx>
- To: cjpengel.dbalert@xxxxxxxxx
- Date: Wed, 29 Jun 2005 10:44:02 +0200 (CEST)
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
