Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Finding data type for a column

Re: Finding data type for a column

From: Bruce Douglas <bruce.douglas_at_bridge.bst.bls.com>
Date: 1996/10/24
Message-ID: <326F7AD1.1266@bridge.bst.bls.com>#1/1

> > I am trying to find out the data type of an column from within my
> >applicaton.
> >What is the ODBC or SQL statment to do that? For example, I have a table
> >called
 

>
>
> Look at the ALL_TAB_COLUMNS or USER_TAB_COLUMNS data dictionary views for the
> definition of all the table columns.
>

At the ODBC level, look at one of these functions: SQLColumns, SQLColAttribute, SQLDescribeCol



Bruce Douglas -- bruce.douglas_at_bridge.bst.bls.com BellSouth Telecommunications
Received on Thu Oct 24 1996 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US