<div>
Should add that you can tweak it to return a number 0 or 1 then add a where clause to your select:<br />
<br />
Select col_val from table where isgood(col_val)=1; &nbsp;
</div>


Should add that you can tweak it to return a number 0 or 1 then add a where clause to your select:

Select col_val from table where isgood(col_val)=1;  

<div>
<div class="content wysiwyg-content">
I am trying to convert a column that is currently a VARCHAR2 into a number using TO_NUMBER, however of the 16,000+ rows there are just one or two that are not numbers and therefore causing the conversion to fail. I am new to functions. How could I write one or possible if Oracle already has one that could flag these individual accounts as 'Not Number'? Hope I explained it fully.
</div>
</div>


I am trying to convert a column that is currently a VARCHAR2 into a number using TO_NUMBER, however of the 16,000+ rows there are just one or two that are not numbers and therefore causing the conversion to fail. I am new to functions. How could I write one or possible if Oracle already has one that could flag these individual accounts as 'Not Number'? Hope I explained it fully.

Oracle Function to find where TO_NUMBER fails

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.