Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Return data type of a column by a function?
The ALL_TAB_COLUMNS and USER_TAB_COLUMNS views contain the data you're
looking for.
SELECT DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'YOUR_TABLE'; If you really need a function then you could embed the above in a PL/SQL function
Cheers
Dave Waterworth
Jimmy wrote in message <377508F7.CDB1557D_at_comp.polyu.edu.hk>...
>Hello all,
> Could anyone tell me is there a function provided to return the data
>type of a column (and the length of a column) in Oracle 7.3.3 (or
>above)?
>
>Thanks,
>Jimmy
>
Received on Sat Jun 26 1999 - 08:06:53 CDT