Sqlplus question
From: Teresa Narvaez <teresa_at_Glue.umd.edu>
Date: 1995/11/06
Message-ID: <Pine.SOL.3.91.951106170541.15521A-100000_at_perl.eng.umd.edu>#1/1
Date: 1995/11/06
Message-ID: <Pine.SOL.3.91.951106170541.15521A-100000_at_perl.eng.umd.edu>#1/1
Hello, I need help in writting a sqlplus code to do the following. I have two tables tab1 and tab2 with the following attributes. tab1 : Name Null? Typethat subnet_id = 'japan' and fac_id in tab1 = fac_id in tab2. Also, the dest_fac_id is itself a fac_id and i want to make sure that i get all the dest_fac_id's only for subnet_id='japan'.
------------------------------- -------- ----
LAYOUT NOT NULL VARCHAR2(20) SUBNET_ID NOT NULL VARCHAR2(5) FAC_ID NOT NULL VARCHAR2(3) X_POS NOT NULL NUMBER(3) Y_POS NOT NULL NUMBER(3) tab2: Name Null? Type
------------------------------- -------- ----
FAC_ID NOT NULL VARCHAR2(3) TRK_GRP_NUM NOT NULL NUMBER(4) SW_TRK_GRP_NUM NOT NULL NUMBER(4) SCLLI VARCHAR2(9) CLLI VARCHAR2(16) NM_TRK_GRP_TYPE NOT NULL NUMBER(1) DEST_FAC_ID VARCHAR2(3) DEST_SW_TRK_GRP_NUM NUMBER(4) UPD_DATE DATE I need to get all the fac_id, x_pos, dest_fac_id such
Thank you,
-Teresa
Received on Mon Nov 06 1995 - 00:00:00 CET