Alguns exemplos de consultas que podem usufruir dos comandos SQL.<\/p>\n
Para descobrir as versoes das transa\u00e7\u00f5es presentes no banco:<\/p>\n
SELECT versions_xid, versions_startscn, versions_endscn, versions_operation, rowid, owner, object_name, object_type
FROM t
VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE;<\/p>\n
Exemplo de utilizacao do Flash back no tempo:<\/p>\n
SELECT DISTINCT TBCLIENTE.*
FROM TBCLIENTE AS OF TIMESTAMP SYSTIMESTAMP – INTERVAL ’20’ MINUTE;<\/p>\n","protected":false},"excerpt":{"rendered":"
Alguns exemplos de consultas que podem usufruir dos comandos SQL. Para descobrir as versoes das transa\u00e7\u00f5es presentes no banco: SELECT versions_xid, versions_startscn, versions_endscn, versions_operation, rowid, owner, object_name, object_typeFROM tVERSIONS BETWEEN SCN MINVALUE AND MAXVALUE; Exemplo de utilizacao do Flash back … Continue lendo