Conf. Change Required at Client side When DB migrated
We changed our database from 8i to 9i.
when we traced the client sql's it is adding a
double quotes with all columns, in the Current sql.
select emp."emp_name", emp."sal" from emp;
But when the same application when we run from 8i
the sql at the backend is
select emp.emp_name,emp.sal from emp;
Is there any performance issues? Is there any client side configurtion
change required to change the above..?
No there are no issues with this. If you extract ddl using OEM, OEM will put these quotes all over the place.
They don't do any harm. be wary when creating tables, adding columns though, you can, via the use of quotes, make table names and column names case sensitive (or even blank!).
Click Here to Expand Forum to Full Width