Determines whether a field is a data or string in oracle.

Oracle uses the translate function in oralce to determine whether a field is data or a string SQL code. The syntax is as follows: TRANSLATE (expr, from_string, to_string) refers to expr content, use the characters in to_string to replace the characters in from_string one by one, for example, select translate ('000000', '\ 000000',' \ ') from dual; the returned result is a blank www.2cto.com select translate ('99999ss99999999999', '\ 1234567890', '\') from dual. The returned result is "ss" to determine whether the value of a field is a number, this function is used to replace all numbers with null values. If the final result is null, it indicates a number; otherwise, it is not a number. Select nvl2 (translate ("999999ss99999999", '\ 000000',' \ '), 'is characters', 'is number') from dual
The returned value is ss, indicating that it is not a number.