SQL statement which returns the length of a table field in the DB

[chriskaza81]

well is there a sql statement so to obtain the length ( in bytes ) of a spesific table field from data base ?

[Hack]

What do you mean by "length of a table field"?

Are you asking about a varchar field, and how many characters it is has been set to?

[brin351]

try DATALENGTH

SELECT DATALENGTH(columnName) AS xxx FROM table ...etc

the result depends on the column datatype

[chriskaza81]

i mean for example if field_name is varchar2(250) , i need a select statement so to have as result 250

[Hack]

i mean for example if field_name is varchar2(250) , i need a select statement so to have as result 250

Ok, that was my question.

Did you try what brin351 suggested?

[chriskaza81]

what do you mean brin351???? i use oracle

[Hack]

Post #3

[chriskaza81]

so do you know how can i do it is there any way???

[GaryMazzone]

Are you talking about using the Desc tablename as in SQL? If so that is not avail from VB (or C# or C or C++). Search the forums I have posted a method for returning table field sizes using Oracle and VB.

[Hack]

This is what I was referring to by brin351 and Post #3

try DATALENGTH

SELECT DATALENGTH(columnName) AS xxx FROM table ...etc

the result depends on the column datatype

Apparently it is moot, as Gary has stated it probably won't work, but I just wanted to clear that up.

[chriskaza81]

yes i want to obtain table field size is there any select statement i can do that??

[GaryMazzone]

Look at this thread http://www.vbforums.com/showthread.php?t=459103

Last post (I think last any way). I posted a method of getting the data back from an Oracle DB.

[chriskaza81]

ok thanks a lot

[Hack]

Does that work for you? Is this question resolved?

[chriskaza81]

yes thnks !!!!