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*Plus: Release 8.1.5.0.0 - Production on Mon Aug 20 07:24:45 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


MSG
--------------------------------------------------------------------------------
World Drug Index 2001 Version 2 -- COPYRIGHT [C] 2001 DERWENT INFORMATION LTD.

 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 DXRN					   NOT NULL VARCHAR2(9)
 SMILES 					    VARCHAR2(4000)
 ISM_SMI					    VARCHAR2(4000)
 SUBSTRUCTURES					    VARCHAR2(350)
 PREF_NAME					    VARCHAR2(50)
 ACTIVITY					    VARCHAR2(250)
 AVG_MOLWT					    NUMBER(8,3)
 XY_COORDS					    CLOB
 XY_COORDS_COMMENT				    VARCHAR2(100)
 MOLFORM					    VARCHAR2(55)
 UPDATE_CODE					    CHAR(15)
 MECHANISM					    VARCHAR2(1250)
 JOURNAL_REF					    VARCHAR2(400)
 JOURNAL_PUB					    VARCHAR2(100)
 JOURNAL_ID					    VARCHAR2(10)
 SUBSTANCE_DESC 				    VARCHAR2(450)
 ADVERSE_EFFECTS				    VARCHAR2(4000)
 PRECAUTIONS					    VARCHAR2(1350)
 INTERACTIONS					    VARCHAR2(950)
 CONTRAINDICATIONS				    VARCHAR2(720)
 INDICATIONS_USAGE				    VARCHAR2(1250)
 REFERENCE					    VARCHAR2(80)
 CONFERENCE					    VARCHAR2(200)
 CONFERENCE_REFNO				    VARCHAR2(55)
 CONFERENCE_DETAILS				    VARCHAR2(55)
 CONFERENCE_WDA_REFNO				    VARCHAR2(25)


ROWS IN WDI
-----------
      67545

 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 DXRN					   NOT NULL VARCHAR2(9)
 APPR_NAME				   NOT NULL VARCHAR2(40)
 APPR_NAME_CODE 				    VARCHAR2(4)


ROWS IN WDI_APN
---------------
	   7324

 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 DXRN					   NOT NULL VARCHAR2(9)
 CAS					   NOT NULL VARCHAR2(11)


ROWS IN WDI_CAS
---------------
	  32297

 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 DXRN					   NOT NULL VARCHAR2(9)
 COMB_PREP				   NOT NULL VARCHAR2(40)
 COMB_PREP_MANUF				    VARCHAR2(40)
 COMB_PREP_COUNTRY				    CHAR(2)
 COMB_PREP_COMPONENTS				    VARCHAR2(375)


ROWS IN WDI_COMB_PREP
---------------------
		34555

 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 DXRN					   NOT NULL VARCHAR2(9)
 DERWENT_NAME				   NOT NULL VARCHAR2(10)


ROWS IN WDI_DRN
---------------
	  47329

 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 DXRN					   NOT NULL VARCHAR2(9)
 NAM					   NOT NULL VARCHAR2(120)


ROWS IN WDI_NAM
---------------
	 104101

 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 DXRN					   NOT NULL VARCHAR2(9)
 TRADENAME				   NOT NULL VARCHAR2(40)
 TRADENAME_MANUF				    VARCHAR2(25)
 TRADENAME_COUNTRY				    VARCHAR2(150)


ROWS IN WDI_TN
--------------
	 74038

 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 DXRN					   NOT NULL VARCHAR2(9)
 US_ADOPTED_NAME			   NOT NULL VARCHAR2(40)
 US_ADOPTED_NAME_CODE				    VARCHAR2(5)


ROWS IN WDI_USAN
----------------
	    8104

 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 DXRN					   NOT NULL VARCHAR2(9)
 INTL_NAME				   NOT NULL VARCHAR2(40)
 INTL_NAME_STATUS				    VARCHAR2(10)


ROWS IN WDI_INN
---------------
	   6810

 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 MSGID					   NOT NULL NUMBER(3)
 MSG						    VARCHAR2(4000)


ROWS IN WDI_DBINFO
------------------
		 1

 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 DXRN						    VARCHAR2(9)
 NAME						    VARCHAR2(120)


ROWS IN WDI_ALLNAMES
--------------------
	      205710

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