SQL*Plus: Release 8.1.5.0.0 - Production on Wed Sep 5 15:58:50 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
--------------------------------------------------------------------------------
Available Chemical Directory [TM] ACD 2000 Version 2 -- Copyright [C] 1983-2001
MDL Information Systems, Inc.  All Rights Reserved.


Elapsed: 00:00:00.01
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID					   NOT NULL NUMBER(7)
 SMI					   NOT NULL VARCHAR2(504)
 PN					   NOT NULL VARCHAR2(80)
 AMW					   NOT NULL NUMBER(8,4)
 D2D					   NOT NULL VARCHAR2(3171)
 ISM						    VARCHAR2(832)
 WARN						    VARCHAR2(50)


ROWS IN ACD
-----------
     270130

Elapsed: 00:00:00.12
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID					   NOT NULL NUMBER(7)
 CAS					   NOT NULL VARCHAR2(11)


ROWS IN ACD_CAS
---------------
	  84935

Elapsed: 00:00:00.05
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID					   NOT NULL NUMBER(7)
 NUM					   NOT NULL VARCHAR2(12)
 SUP					   NOT NULL VARCHAR2(12)
 NAM					   NOT NULL VARCHAR2(200)
 GRA					   NOT NULL VARCHAR2(4)
 PUR						    VARCHAR2(10)
 COS						    VARCHAR2(32)
 DPG						    NUMBER(9,3)
 REM						    CLOB
 UPD						    VARCHAR2(4)


ROWS IN ACD_CAT
---------------
	1425999

Elapsed: 00:00:06.58
 Name					   Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID					   NOT NULL NUMBER(7)
 NAM					   NOT NULL VARCHAR2(157)


ROWS IN ACD_NAM
---------------
	      0

Elapsed: 00:00:00.01
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