SELECT c$dcischem.ddpackage.fsetdebug(9) FROM DUAL;
SET PAGESIZE 100;
COLUMN CAS HEADING CAS FORMAT A20;
COLUMN DXRN HEADING DXRN FORMAT A20;
COLUMN SMI HEADING SMILES FORMAT A20;
COLUMN SIM FORMAT 9.99;
SELECT DISTINCT WDI_CAS.CAS,WDI.DXRN,SMI,tanimoto(SMI,'NCCc1cc(O)c(O)cc1') "SIM"
	FROM WDI_CAS,WDI
	WHERE tanimoto(SMI,'NCCc1cc(O)c(O)cc1')>0.90
	AND WDI.DXRN=WDI_CAS.DXRN(+) ORDER BY tanimoto(SMI,'NCCc1cc(O)c(O)cc1') DESC;
QUIT;


SQL*Plus: Release 8.1.5.0.0 - Production on Thu Aug 9 15:17:41 2001

(c) Copyright 1999 Oracle Corporation.  All rights reserved.


Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.2 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production


C$DCISCHEM.DDPACKAGE.FSETDEBUG(9)
---------------------------------
				1


CAS		     DXRN		  SMILES		 SIM
-------------------- -------------------- -------------------- -----
51-61-6 	     DOPAMINE		  NCCc1ccc(O)c(O)c1	1.00
1927-04-4	     HODOPAMI5		  NCCc1cc(O)c(O)c(O)c1	 .97
588-05-6	     TYRAMINEM		  NCCc1cccc(O)c1	 .97
62-31-7 	     DOPAMIHCL		  Cl.NCCc1ccc(O)c(O)c1	 .95
66432-25-5	     MEDOPAMIB		  CC(CN)c1ccc(O)c(O)c1	 .95
51-67-2 	     TYRAMINE		  NCCc1ccc(O)cc1	 .92
1199-18-4	     OXIDOPAMI		  NCCc1cc(O)c(O)cc1O	 .92
501-15-5	     DEOXYADRE		  CNCCc1ccc(O)c(O)c1	 .92
21581-37-3	     DIMEDOPNN		  CN(C)CCc1ccc(O)c(O)c	 .90
					  1

7224-66-0	     CORYNEINE		  C[N+](C)(C)CCc1ccc(O	 .90
					  )c(O)c1


10 rows selected.

Disconnected from Oracle8i Enterprise Edition Release 8.1.5.0.2 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production