Re: Vs: Reserved word? or not?
Date: Wed, 24 Sep 2008 08:31:49 +0300
Most of keywords are same v$reserved_words but on 10.2 I checked that total of 235 keywords 134 exists in view(total 1146 rows) and 101 don't, like data and language and so on.
I don't know that there would be another view for keywords... If someone does, please let us know...
>>> "Jack van Zanen" <jack_at_vanzanen.com> 24.9.2008 8:21:20 >>>
Ah I see, is there an oracle view for these as well?
2008/9/24 Teijo Lallukka <teijo.lallukka_at_edita.fi>
> Language is PL/SQL keyword so it should not be used as columns name or
> table name etc.
> >>> "Jack van Zanen" <jack_at_vanzanen.com> 24.9.2008 7:17:59 >>>
> Hi All
> We have an external table that reads from a datafile just fine in Oracle
> However we upgraded our test environment to 10G and now it complaints about
> the column name "LANGUAGE". It expects double quotes.
> I had a look in the v$reserved_words view and do not see this word as
> Changing the column name to language1(or something) fixes the problem, but
> I am wondering why we need to do this.
> J.A. van Zanen
-- J.A. van Zanen -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 24 2008 - 00:31:49 CDT