987900 wrote:The selection of a data type for a given data element should be based on the nature of the data, not the convenience of an inexperienced programmer. In the long run, using the correct data type (and learning how to work with it) will work to the convenience of the now experienced programmer.
Is it possilble to convert a table column from clob to varchar if the column having text data?
Scenario is :
one dev needs a column col1 in a table (tab) as varchar data type.
The datatype of that column col1 is clob and having text data.