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?
Hi,
On 11/8/07, Sean N. [email protected] 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