-
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.
example
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..?
Thanks
-
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!).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|