THE Wiki

User Tools

Site Tools

Trace: • tandoor_rezepte • kartoffeln • oracle
oracle

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
oracle [2025/12/09 14:24] – mduerschoracle [2025/12/15 08:24] (current) – [SELECTS] mduersch
Line 568: Line 568:
    select LOG_MODE from v$database;    select LOG_MODE from v$database;
    select name from V$database;    select name from V$database;
 +   # flashbackquery
 +   select count(1) from somewhere 
 +                 AS OF TIMESTAMP TO_TIMESTAMP('2025-12-12 16:00', 'YYYY-MM-DD HH24:MI:SS') 
 +           where 
 +                 something is NULL;
  
 ==== GRANTS ==== ==== GRANTS ====
oracle.1765290240.txt.gz · Last modified: by mduersch