wdi.cgi

Server: User: Pass:
Query:

SMILES/SMARTS:    Isomeric

   Exact structure match
   Similar structures    Tversky  A:  B:
   Substructure
   SMARTS match
NAME: Exact Substring  Case sensitive
DXRN:
CAS:
Output options:

Datatypes:

Show SQL:   Hide form:   Show duplicates:   Show # of hits only:  
Col width:   Max output lines:
DayCart debug level: 0,1,5,9
SQL:
      

SET PAGESIZE 100;
COLUMN SMILES HEADING SMILES FORMAT A20;
SELECT COUNT(*) FROM (
	SELECT DISTINCT SMILES
	FROM WDI
	WHERE matches(SMILES,'[N;H2,H1;!$(NC=*)]')=1
	);
QUIT;


SQL*Plus: Release 8.1.5.0.0 - Production on Mon Aug 20 07:55:36 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


  COUNT(*)
----------
     15896

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
Daylight Chemical Information Systems Inc.
support@daylight.com