From: KUBO Takehiro <kubo@...>
Date: 2007-11-11T12:34:07+09:00
Subject: Re: Obtaining column type in OCI8

Hi,

On 11/8/07, Sean Nakasone <seannakasone@yahoo.com> wrote:
> Using the OCI8 module, how does one obtain the type of a column in a
> table?  For example, how do we know if a column is a VARCHAR or a NUMBER?

Column types of an existing table, or of a query?
For the former, you can get the column types by querying
USER_TAB_COLUMNS data dictionary.
For the latter, you have no way now. It will be supported at the next release.
  http://rubyforge.org/forum/forum.php?thread_id=17986&forum_id=1078