Hi. I'm using Oracle Analytic Views (from 19c) as defined here: https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/overview-analytic-views.html I can create measures with simple aggregations (eg: SUM, COUNT, MIN), but I can't create a measure that collates COUNT(...

Hi Tom, Suppose I am having following SQL query UPDATE TB38O SET G000KE = (SELECT TB39G.A6000D FROM TB39G WHERE TB39G.A0020C = TB38O.A020KF AND TB39G.A0090C = TB38O.A090KF AND TB39G.A1010Y = TB38O.B010KF AND TB39G.A6000Y = TB38O.G000KF AND TB39G.A0230Z = TB38O.A230KF AND TB39G.

Hello, Is there any way to exclude a list of tables while doing DBMS_STATS.GATHER_SCHEMA_STATS? DBMS_STATS.LOCK_TABLE_STATS doesn't answer my need exactly. Best regards, Amine

I have been working on a project to password protect the files generated by Oracle forms and reports. Since this will only be for internal users, I have used PDFUSER, PDFOWNER utilities given by Oracle. The next tasks is to password protect the files generated by UTL_FILE. I trie...

I need oracle 8i enterprise edition and Devloper 6i can u teel me the links for them to download I need them very much ...