Is there a way to prevent double quotes appearing around columns

[SaKa]

Hi,
When i am typing a SQL statement , when using alias , when i type alias and dot, PLSQLD drops down and shows available columns where i can select from. It seems sometimes the columns selected appear enclosed in double quotes. Technically this is correct as some views were created this way, what i want to know if there is a way to not use double quotes; the drop down dont use double quotes so i like the result to not include double quotes too.

eg:- PLSQLD generated code:
Select t."order_no" from view1 t
I wish it created as below:
Select t.order_no from view1 t

Thanks in advance
Sak

 

[Marco Kalter]

There are 2 ways to omit the quotes:

1. Remove them from the view definition. Specify the column names in the same way as you would like to see them in your own queries.
   
2. Disable the "Use original case if possible" on the Code Assistant preference page (Configure > Preferences > Code Assistant). Now the Code Assistant items will be formatted based on general rules instead of the source (in this case a view source) where they are defined.

 

[Frank Kintrup]

Thank you! These quotes were driving me nuts and I didn't know which setting to change ;-)