All Questions
3 questions
2
votes
1
answer
115
views
Seek to get acceptable performance of SQL request (SOLVED)
Goal: I want to output all non-standard FK constraints from clients DB, versus our "standard" DB (which contains, by default, 2,631 FK).
Trial: I wrote this code:
...
- 169
5
votes
2
answers
301
views
Query for building a view
I am currently trying to improve on a query that is being used to build a view. The query is in PL/SQL, in an Oracle database. There are 3 different types of reports (100,200, and 300) that are ...
- 151
3
votes
2
answers
1k
views
Oracle PL/SQL decryption function breaking index?
I have a package called pkg_crypto.
My select looks like this:
...
user10103