James (Jim) Bentley" wrote: > Brad, > Try following: > SEL T1.SYS_TABLE_ID, + T2.SYS_TABLE_NAME,T1.SYS_COLUMN_NAME,T1.SYS_TYPE_NAME > + > FROM SYS_COLUMNS T1, SYS_TABLES T2 WHERE T1.SYS_TYPE_NAME = 'NOTE' > AND T1.SYS_TABLE_ID=T2.SYS_TABLE_ID AND + T2.SYS_TABLE_TYPE='TABLE'
Jim, Thanks so much! After finding sys_type_name col everything unfolded wonderfully. Regards, Brad
begin:vcard n:Davidson;Brad tel;fax:909-736-4699 tel;work:909-736-4690 x-mozilla-html:FALSE url:www.aero-craft.com org:Aero-Craft Hydraulics, Inc.;Customer Support adr:;;392 North Smith Avenue;Corona;CA;92880-6971;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Manager fn:Brad Davidson end:vcard
