Hi, I'm trying to learn some sql mainly to perform queries for issue research. I've connected SQL Developer and am slowly figuring a few things out, but when I query I have to prefix tables names with ‘apps.’ the last time I used sql I did not - that was some year ago. How can this be avoided?
Simple example: if I query “desc mtl_system_item;” – table not found
but “desc apps.mtl_system_item;” - all information returned