I have a query that runs on several different schemas in the database, and there is a table that specifies that some schemas have, and if the value exists, it returns.
SELECT t.coluna1 ,t.coluna2 ,(SELECT coluna3 FROM tabelaquepodenaoexistir WHERE coluna4 = 'S' AND coluna5 = 'N') as coluna 3 FROM tabelaqueexisteemtodosschemas t
In some schemas this query returns what it should return, but in some it returns the error:
ORA-00942: table or view does not exist
- Can not use DBA or SYS access.
- I can not create this table.
- I can not create a function in the schema.