Hi! 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... -Teijo >>> "Jack van Zanen" <jack@xxxxxxxxxxxx> 24.9.2008 8:21:20 >>> Ah I see, is there an oracle view for these as well? Brgds Jack 2008/9/24 Teijo Lallukka <teijo.lallukka@xxxxxxxx> > Hi! > > Language is PL/SQL keyword so it should not be used as columns name or > table name etc. > > > http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/reservewords.htm#LNPLS019 > > > -Teijo > > >>> "Jack van Zanen" <jack@xxxxxxxxxxxx> 24.9.2008 7:17:59 >>> > Hi All > > We have an external table that reads from a datafile just fine in Oracle > 9i. > 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 > reserved. > Changing the column name to language1(or something) fixes the problem, but > I am wondering why we need to do this. > > > Brgds > > -- > J.A. van Zanen > > -- > //www.freelists.org/webpage/oracle-l > > > -- J.A. van Zanen -- //www.freelists.org/webpage/oracle-l