Dear all, I have a view. When I select data, I have to use double quotation on selected column name, for instance: select "assy_no" from myView; if I try select assy_no from myView I will get error: ORA-00904: "ASSY_NO": invalid identifier
When I query on the tables used by the view, double quotation is not required. Why the column name on my view requires double quotation? Please help.
Since it works in SSMS, there isn't anything that we can help with here. I suspect the database driver doesn't like the underscore when querying the view. But it really shouldn't matter. You could try updating your database driver to the latest and greatest, but outside of that you are stuck double quoting these. There isn't anything we can do on the SQL Server side to fix it, since it's fine on the SQL Server side.