I have a column varachar2(2000).
Now, While inserting/updating this column, if the data is more than 2000 bytes, i want to truncate that to 2000 length and discard rest of the data
how can i achieve this ?
Thx
Printable View
I have a column varachar2(2000).
Now, While inserting/updating this column, if the data is more than 2000 bytes, i want to truncate that to 2000 length and discard rest of the data
how can i achieve this ?
Thx
substr(VariableName,1,2000)
Thx.