Question : I have several questions: 1) If Oracle manages both High-water Mark and Low High-water Mark in ASSM tablespace […]
Category: Oracle
Combine 2 SQL Queries
Question : How do I combine these 2 queries? select a, b, c from MY_TABLE where date < sysdate+1 AND […]
Comments in EXPDB parameter file
Question : Is there a way to put comments in a data pump export parameter file? Answer : Yes, by […]
What does TOAD do, when I terminate script execution?
Question : When it stops the execution of a long running script. The script terminating needs even longer then the […]
large data movement
Question : I would like to move billions of rows from schema1.table1 to new schema2.table2 where table2 is a refactored […]
Can PostGIS or Oracle Spatial and Graph scale to hundreds of terabytes of data, or should I use a NoSQL option like DynamoDB? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Shopping list question – questions about which […]
Oracle SQL – CASE in a WHERE clause
Question : Is it possible to somehow do this? WITH T1 AS ( SELECT 1 AS SEQ, ‘NOTHING 1’ AS […]
Stored procedure using cursors [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Does an order by clause have a negative effect on performance?
Question : I couldn’t find the answer by googling. I only over heard a senior dev telling a junior dev […]
Standard Meaning of “Bounce the Database” [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]