Hi,

I have imported a table from excel using sqlnet. Now my table columns have 255 length and some column have only 2 character length. Eventhough I am using varcahr2(), I want to create another table and import this data in that. How do I find a column data maximum width, so that I can create another table using that width. Please help me.

Regards
Immanuel

try tu use multiple columns, one way to find the length of a text in oracle is by using this command : select length(fieldname) from tablea;
You can also use the long datatype in oracle.

What do you mean under "How do I find a column data maximum"? Do you want concatenate data from more columns of old table? If it true, so
you can calculate maxlength of your data from query:

SELECT max(data_length)
  FROM ( SELECT nvl(length(field1||field2||...||fieldN),0) data_length
           FROM yourTable
       )

Oracle allowing to set of column size till 4000 characters for a text data. If you have maxsize of data more than 4000 you must use the long datatype (as write jlnashrod)