User Tools

Site Tools


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.txt · Last modified: by mduersch