in create table some columne names in double quotes why?

gahuja

Hello

I noticed some of the below named column names in create table command in deployment script are being shown in double quotes

OWNER,MODEL,SUPPORT

Would like to confirm is it just because they are keywords in Oracle thats why they are in double quotes

If so would like to know what difference it makes to put it in double quotes as anyway we will be able to create table with these column names without putting double
quotes as well

Regards
Gagan

richardjm

The tool is more conservative when recognising oracle keywords. As although the double quotes are sometimes not strictly necessary because Oracle is clever enough to understand context that prevents a keyword from appearing in that location.

However our parser isn't clever enough to understand context so we have to quote keywords wherever they appear (replacing the parser is on my todo list but not very high currently).