Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Determining the defined maximum length of a VARCHAR field
Is there an easy way to determine the defined length of a
VARCHAR/VARCHAR2 field in Oracle SQL? I write a lot of interfaces
that import data, and many times I'd like to simply truncate the
incoming text data to the length of the existing varchar column in a
table. I know I can query 'user_tab_columns', but it seems that there
should be a built-in function that takes the table name and the
varchar column name and returns the defined maximum length for the
column.
Received on Wed Mar 12 2003 - 09:33:33 CST