Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, Vannessa.
Asked: May 16, 2017 - 1:18 pm UTC
Last updated: May 17, 2017 - 8:40 pm UTC
Version: oracle 12c
Viewed 1000+ times
SQL> SELECT deptno, dname, 2 VERSIONS_STARTTIME 3 ,VERSIONS_XID 4 ,VERSIONS_OPERATION 5 FROM dept VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE; DEPTNO DNAME VERSIONS_STARTTIME VERSIONS_XID V ---------- -------------- ------------------------ ---------------- - 50 UNKNOWN 03-SEP-08 11.08.15 PM 04000700EA030000 U 30 UNKNOWN 03-SEP-08 11.08.15 PM 04000700EA030000 U 20 NERDS 03-SEP-08 11.07.57 PM 090016001D050000 U 20 R&D 03-SEP-08 11.07.48 PM 05000B0074040000 U ...
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!