Hello, I have multiple baselines and after migrating the application many of them got not reproducible. The reason was renaming of some indexes during the migration. I have renamed those indexes back to the original name. My question is how I get Oracle to set those baseline back...

(https://livesql.oracle.com/ords/livesql/s/da34i74lkmxt2mqrtp0k4xsk6 ) (I was able to format better with screenshots on the Oracle forums - https://forums.oracle.com/ords/apexds/post/help-solving-a-logical-problem-using-analytical-query-3778) Hi, I am trying to solve a problem us...

Hello Chris. Hello Connor, I’m struggling with a performance issue … We have a single big table (167 million of rows, 118 columns). For ad hoc queries we have created a simple Apex application with 15 most important columns as filters. To avoid long running queries we start a sim...

Can someone please provide Oracle sql query to get below output? Deptno Dept Name No. of emp 10 a 10 b 20 c 30 20 d 40 e 50 f 60 30 g 70 h 80 i 90

Hello ASK TOM team, Recently our client has come out with a requirement to be able to rollback database part of any application deployment. Now in our case, the application deployment can mean any or all of the following from a database perspective: a) PL/SQL code (functions, pac...