Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Finding data type for a column
> > 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
![]() |
![]() |