Subversion Repositories DevTools

Rev

Rev 64 | Blame | Compare with Previous | Last modification | View Log | RSS feed 

/* OS Details */
SELECT os.OS_ID,
           os.OS_NAME,
           os.NODE_ID,
           os.OS_COMMENTS,
                 os.NODE_SPEC_FILE,
           os.NOT_XML,          
           obe.base_env_id,
       be.BASE_ENV_NAME  
  FROM OPERATING_SYSTEMS os,
           BASE_ENV be,
       OS_BASE_ENV obe 
 WHERE os.OS_ID = :OS_ID
   AND obe.OS_ID (+) = os.OS_ID
   AND obe.BASE_ENV_ID = be.BASE_ENV_ID (+)