How can we help you today? How can we help you today?

in create table some columne names in double quotes why?

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
gahuja
0

Comments

1 comment

Sort by
  • 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).
    richardjm
    0

Add comment

Please sign in to leave a comment.