top of page
Search

Flashback Query Example

-- Change table name and interval to whatever you need

select *

from fnd_user

as of timestamp (systimestamp - interval '10' minute);

 
 
 

Recent Posts

See All
Get DDL for Oracle object

set feed off set long 1000000 set longchunksize 1000000 set pages 0 set lines 32767 set trimspool on set feed off set wrap on set...

 
 
 
Foreign key constraint violation

/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id...

 
 
 

Comentarios


bottom of page