<div>
Or below ones.. 
 

<pre><code class="code-1 nolinks" id="code-20-42355044-1">SELECT * FROM
(
SELECT regexp_replace('INV242436','[0-9]','') a from dual UNION ALL
SELECT regexp_replace('APPY246578','[0-9]','') a from dual UNION ALL
SELECT regexp_replace('PO141423','[0-9]','') a from dual UNION ALL
SELECT regexp_replace('FSO897623','[0-9]','') a from dual UNION ALL
SELECT regexp_replace('APAC126756','[0-9]','') a from dual
)o
</code></pre>
 
or 

<pre><code class="code-1 nolinks" id="code-20-42355044-2">SELECT * FROM
(
SELECT regexp_replace('INV242436','[[:digit:]]','') a from dual UNION ALL
SELECT regexp_replace('APPY246578','[[:digit:]]','') a from dual UNION ALL
SELECT regexp_replace('PO141423','[[:digit:]]','') a from dual UNION ALL
SELECT regexp_replace('FSO897623','[[:digit:]]','') a from dual UNION ALL
SELECT regexp_replace('APAC126756','[[:digit:]]','') a from dual
)o
</code></pre>
 
Output 
 

<pre><code class="code-1 nolinks" id="code-20-42355044-3"> 	A
1	INV
2	APPY
3	PO
4	FSO
5	APAC
</code></pre>
</div>

<div>
We can also use Translate function for this kind of requirement. 
 

<pre><code class="code-1 nolinks" id="code-20-42355047-1">WITH CTE AS
(
	select 'INV242436' a from dual union all
	select 'APPY246578' from dual union all
	select 'PO141423' from dual union all
	select 'FSO897623' from dual union all
	select 'APAC126756' from dual
)
SELECT translate(a, 'a0123456789', 'a') a FROM CTE
</code></pre>
 
OUTPUT 
 

<pre><code class="code-1 nolinks" id="code-20-42355047-2"> 	A
1	INV
2	APPY
3	PO
4	FSO
5	APAC
</code></pre>
</div>

<div>
<div class="content wysiwyg-content">
I want stripout numeric data from the column value 
 
ex :: Column name = abc 
abc having the values like 
INV242436, 
APPY246578, 
PO141423, 
FSO897623, 
APAC126756 
I want like this.. 
INV, 
APPY, 
PO, 
FSO, 
APAC
</div>
</div>

I want stripout numeric data from the column value

ex :: Column name = abc
abc having the values like 
INV242436, 
APPY246578, 
PO141423,
FSO897623,
APAC126756
I want like this.. 
INV,
APPY,
PO,
FSO,
APAC

stripout numeric data from the column value in oracle

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

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.