quote:Originally posted by immanuelsamuel
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.
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:
FROM ( SELECT nvl(length(field1||field2||...||fieldN),0) data_length
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)