Re: Varchar or Integer

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 08 Nov 1999 18:53:00 +0800
Message-ID: <3826AB8C.4CC3@yahoo.com>

Mark Young wrote:
>
> I am writing a VB app and need to know through a SQL query the datatype
> of a field. Can anybody tell me what the syntax is to get the datatype
> of a DB field?

You could always have a look at USER_TAB_COLUMNS (or ALL_TAB_COLUMNS) --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Nov 08 1999 - 04:53:00 CST