How to set schema to APPS before starting work on SQL Developer or Toad

Ever wondered why your tried and tested SQL query is not fetching data !!

You realize that prefixing each table_name with APPS solves the issue but that's a tedious process.

So..to do it once for all for the session that you are logged in. Try the below SQL

alter session set current_schema = APPS;

Now your query shall work as usual.

Note: For xla tables you might still have to use xla as prefix as some xla tables store the data in xla schema.

For Ex. select * from xla.xla_transactions_entities;

We will learn more on the xla tables in another post :)