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...

How do I know which tablespaces have which data files and their path on disk?

Hi Team, This is the first time I am asking question on asktom, while I am very much thankful to the solutions you have provided and kept helping people always. We want to add 60 CLOB columns to the table which is around 17TB in size. This is a datawarehouse DB and data loading t...