Oracle9i Designer Migration Guide Appendix A |
Contents

# PVCS/VM administration query

    select distinct obj.vmproject  project

    ,      obj.workfile   workfile

    ,      obj_d.revision Develop

    ,      obj_t.revision Test

    ,      obj_a.revision Accept

    ,      obj_p.revision Prod

    from   (select log1.vmproject

            ,      log1.workfile

            ,      grp1.revision

            from   solvctgrps grp1

            ,      solvctlogs log1

            where  grp1.archiveid  = log1.archiveid

            and    grp1.vmproject  = log1.vmproject

            and (grp1.groupname    = 'develop'

                 or grp1.groupname = 'test'

                 or grp1.groupname = 'accept'

                 or grp1.groupname = 'prod'

                )

           ) obj

    ,      (select log2.workfile

            ,      grp2.revision

            from   solvctgrps grp2

            ,      solvctlogs log2

            where grp2.archiveid = log2.archiveid

            and   grp2.vmproject = log2.vmproject

            and   grp2.groupname = 'develop'

           ) obj_d

    ,      (select log3.workfile

            ,      grp3.revision

            from   solvctgrps grp3

            ,      solvctlogs log3

            where  grp3.archiveid = log3.archiveid

            and    grp3.vmproject = log3.vmproject

            and    grp3.groupname = 'test'

            ) obj_t

    ,      (select log4.workfile

            ,      grp4.revision

            from   solvctgrps grp4

            ,      solvctlogs log4

            where  grp4.archiveid = log4.archiveid

            and    grp4.vmproject = log4.vmproject

            and    grp4.groupname = 'accept'

            ) obj_a

    ,      (select log5.workfile

            ,      grp5.revision

            from   solvctgrps grp5

            ,      solvctlogs log5

            where  grp5.archiveid = log5.archiveid

            and    grp5.vmproject = log5.vmproject

            and    grp5.groupname = 'prod'

            ) obj_p

    where   obj.workfile = obj_d.workfile(+)

    AND     obj.workfile = obj_t.workfile(+)

    AND     obj.workfile = obj_a.workfile(+)

    AND     obj.workfile = obj_p.workfile(+)

    order by obj.workfile

     n     /

Prev | Next
| Copyright © 2002, Oracle Corporation. All Rights Reserved. |
Contents