Hi Sherry. Welcome back to ITKE.
ISNUMERIC is a T-SQL function, and Oracle doesn’t have an equivalent.
However, you can easily build your own.
Something like this:
<pre>CREATE OR REPLACE FUNCTION isnumeric(p_value IN VARCHAR) RETURN NUMBER IS
l_value := p_value;
WHEN value_error THEN
After creating this function, your query should run without errors.
P.S. DBMS = Database management system (i.e. Oracle, Sql Server, etc.)