How to get column size of a table

[kasukur]

Hi

Can someone please help me... It's seem like there is not a single way to get the column size from a dataset, table, datarow from SQL/Oracle in .Net using C# or VB

Thanks in advance

[debasisdas]

Try to use this
select max(vsize(colum _name)) from table_name
in oracle

[Plater]

What do you mean by column size?
How many bytes are stored for each entry in the column?
The DataType of the column?
The displayable width of the column?

[kasukur]

Thanks for your replies

i can't use select query, what i need to do is call a stored procedure which returns me a cursor and i need to find out the actual defined size of each column

Hope i'm clear

thanks
Sri

[Plater]

A select query would return equiv of a cursor, I tjhink you have to query special system databases to get what you want. (there is a system database that stores information about all the created databases) I am not sure which one or what, but use a database explorer program and pick through your system databases to see it maybe?