Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/* OS Details */
2 
SELECT os.OS_ID,
3 
	   os.OS_NAME,
4 
	   os.NODE_ID,
5 
	   os.OS_COMMENTS,
6 
	   obe.base_env_id,
7 
       be.BASE_ENV_NAME
8 
  FROM OPERATING_SYSTEMS os,
9 
	   BASE_ENV be,
10 
       OS_BASE_ENV obe
11 
 WHERE os.OS_ID = :OS_ID
12 
   AND obe.OS_ID (+) = os.OS_ID
13 
   AND obe.BASE_ENV_ID = be.BASE_ENV_ID (+)