Listing A

SQL> col description format a25

SQL> colstarttime format a25

SQL> 

SQL> SELECT partid, descr description,
  2         versions_operation o,
  3         versions_startscnstartscn,
  4         versions_starttimestarttime
  5  FROM SCOTT.parts
  6     VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE
  7  WHERE
  8     partid = 7032;


    PARTID DESCRIPTION               O   STARTSCN STARTTIME                     

---------- ------------------------- - ---------- -------------------------     

      7032 Cog, 1", aluminum         U     721191 03-MAY-06 10.53.47 AM         

      7032 Sprocket, 1", aluminum    U     721169 03-MAY-06 10.53.14 AM         

      7032 Cog, 1", aluminum         U     721146 03-MAY-06 10.52.23 AM         

      7032 Sprocket, 1", aluminum    I     720716 03-MAY-06 10.51.07 AM