Friday, August 3, 2012

How to find the navigation of a Process


SELECT DISTINCT RTRIM( REVERSE ( SYS_CONNECT_BY_PATH(REVERSE (portal_label), ' > ')) ,' > ') PATH FROM PSPRSMDEFN
      WHERE portal_name = 'EMPLOYEE' 
        AND portal_prntobjname = 'PORTAL_ROOT_OBJECT' 
  START WITH portal_uri_seg2 IN (
                        SELECT DISTINCT pnlgrpname 
                        FROM ps_prcsdefnpnl 
                        WHERE prcsname in ('PROCESS_NAME_HERE') ) 
  CONNECT BY PRIOR portal_prntobjname = portal_objname;




OCI - Attach Block Volume to Windows VM

Tip: Although creating and attaching Block Storage to a Windows VM is pretty straightforward (OCI documentation is pretty good for that), th...