Recognize double quotes for object names in the same way as square brackets.
Please enable SQL Prompt to have the same behavior with double quotes as with square brackets.
For example, typing:
SELECT * FROM [MyTable]
will allow the expansion of the asterisk, while
SELECT * FROM "MyTable"
does not.
SET QUOTED_IDENTIFIER is ON by default. Also, many Oracle "converts" use the format "SchemaName"."TableName".
1
vote
artim
shared this idea
This is included in SQL Prompt 6.3, which can be downloaded from http://www.red-gate.com/products/sql-development/sql-prompt/