Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Mar 06, 2012 02:27 AM|LINK
I was using table name to fetch the data. Now I have changed it to schemaname.table in the statement. It is working fine. But my doubt is why shoould we give schema name for sure? why is it not working with table name?
If I have to make changes to all my sql statement like select * from table to select * from cp.table , what should I do? or do we have any work around for this where all my sql statements consider schema name included by default?