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 DXRN HEADING DXRN FORMAT A20;
COLUMN SMILES HEADING SMILES FORMAT A20;
COLUMN TRADENAME HEADING TradeName FORMAT A20;
SELECT DISTINCT WDI_ALLNAMES.DXRN,SMILES,WDI_TN.TRADENAME
	FROM WDI,WDI_TN,WDI_ALLNAMES
	WHERE UPPER(WDI_ALLNAMES.NAME)=UPPER('zantac')
	AND WDI_ALLNAMES.DXRN=WDI.DXRN(+)
	AND WDI_ALLNAMES.DXRN=WDI_TN.DXRN(+);
QUIT;


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


DXRN		     SMILES		  TradeName
-------------------- -------------------- --------------------
RANITIDIN	     CNC(=C[N+](=O)[O-])N AZANTAC
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N CORALEN
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N GASTRIAL
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N HISTAC
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N MIDERAN
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N PEPTORAN
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N QUANTOR
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N RANACID
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N RANEKS
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N RANIBOS
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N RANIDIF
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N RANILONGA
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N RANIPLEX
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N RANISAN
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N RANIT
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N RANITAB
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N RANITAL
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N RANITINE
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N RATICINA
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N SELTAK
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N TANIDINA
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N ULCERAN
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N ULCODIN
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N ULCOREN
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N ULCURAN
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N ULGASIN
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N UMAREN
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N ZANTAC
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N ZANTAC-75
		     CCSCc1ccc(CN(C)C)o1

RANITIDIN	     CNC(=C[N+](=O)[O-])N ZYLIUM
		     CCSCc1ccc(CN(C)C)o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ACIDEX
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ACIDEX-AMP
		     ])NCCSCc1ccc(CN(C)C)
		     o1

DXRN		     SMILES		  TradeName
-------------------- -------------------- --------------------

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ACLORAL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ALTER-H2
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ANISTAL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ANTAK
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- APO-RANITIDINE
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- AXOBAN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- AZANTAC
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- BAROXAL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- BINDAZAC
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- BLUMOL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- CORALEN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- DANITIN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ENTERAL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- EPADOREN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- EZOPTA
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- GALEBIRON
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- GASTRIAL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- GASTRIDINA
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- GASTROLAV
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- GASTROSEDOL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- LABEL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- LOGAST
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- LOGAT
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- LOMADRYL
		     ])NCCSCc1ccc(CN(C)C)
		     o1


DXRN		     SMILES		  TradeName
-------------------- -------------------- --------------------
RANITIHCL	     Cl.CNC(=C[N+](=O)[O- LUMAREN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- MAURAN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- NIPODUR
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- NORIDE
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- PEPTAB
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- PRO-RANITIDINE
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- PTINOLIN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- QUANTOR
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RADAN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RAN-H2
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANCET
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANDIN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANIBEN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANIBLOC
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANIDIL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANIDIN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANIDINE
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANILONGA
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANIMEX
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANIOGAS
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANIPLEX
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANISEN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANITAC
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANITIDINA
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANITIDINE-HYDROCHLO

DXRN		     SMILES		  TradeName
-------------------- -------------------- --------------------
		     ])NCCSCc1ccc(CN(C)C) RIDE
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANIX
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANK
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANOBEL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANTACID
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RANUBER
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RATICINA
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RESTOPON
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RETAMIN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ROSIMOL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ROTHONAL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- RUBIULCER
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- SANTANOL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- SMARIL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- SOSTRIL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- SYNTHOMANET
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- TANIDINA
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- TAURAL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- TEOGRAND
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- TERPOSEN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- TINIDINA
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- TORIOL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- TRIGGER
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- UL-PEP
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ULCEX
		     ])NCCSCc1ccc(CN(C)C)

DXRN		     SMILES		  TradeName
-------------------- -------------------- --------------------
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ULCOREN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ULCURAN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ULSAL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ULTIDIN
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ULTIDINE
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- VERLOST
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- VIZERUL
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ZANTAC
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ZANTAC-IV
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ZANTIC
		     ])NCCSCc1ccc(CN(C)C)
		     o1

RANITIHCL	     Cl.CNC(=C[N+](=O)[O- ZYLIUM
		     ])NCCSCc1ccc(CN(C)C)
		     o1


116 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
Daylight Chemical Information Systems Inc.
support@daylight.com
ACTIVITY
ADVERSE_EFFECTS
APPR_NAME
APPR_NAME_CODE
AVG_MOLWT
CAS
COMB_PREP
COMB_PREP_COMPONENTS
COMB_PREP_COUNTRY
COMB_PREP_MANUF
CONFERENCE
CONFERENCE_DETAILS
CONFERENCE_REFNO
CONFERENCE_WDA_REFNO
CONTRAINDICATIONS
DERWENT_NAME
DXRN
INDICATIONS_USAGE
INTERACTIONS
INTL_NAME
INTL_NAME_STATUS
ISM_SMI
JOURNAL_ID
JOURNAL_PUB
JOURNAL_REF
MECHANISM
MOLFORM
OTHERNAME
PRECAUTIONS
PREF_NAME
REFERENCE
SMILES
SUBSTANCE_DESC
SUBSTRUCTURES
TRADENAME
TRADENAME_COUNTRY
TRADENAME_MANUF
UPDATE_CODE
US_ADOPTED_NAME
US_ADOPTED_NAME_CODE
XY_COORDS
XY_COORDS_COMMENT