Isaac
Lifelong Learner
- Local time
- Today, 06:35
- Joined
- Mar 14, 2017
- Messages
- 8,777
Here is a page that may help:
I would start simple. Test a very small bit of SQL with different identifier styles until one works:
(note, in that example I just took a guess at what one of your 'identifier styles' might be if you wanted to test it, you may have to test a few).
You may need to find out from your DBA what is the 'safest' (and probably most verbose) way of selecting from that view in the identifier portion
Schema Object Names and Qualifiers
docs.oracle.com
I would start simple. Test a very small bit of SQL with different identifier styles until one works:
Code:
select * from "schema"."table" where rownum<5
You may need to find out from your DBA what is the 'safest' (and probably most verbose) way of selecting from that view in the identifier portion