<div>
check with this <br />
SUBSTR(columnname ,instr(columnname , '_') &nbsp;, instr(columnname, '_', 1, 2))<br />

</div>


check with this
SUBSTR(columnname ,instr(columnname , '_')  , instr(columnname, '_', 1, 2))


<div>
Quite a few ways to do this. One, probably not the most efficient:<br />
LEFT(SUBSTR(column1,INSTR(<wbr />column1,'_<wbr />'),LEN(col<wbr />umn1)),INS<wbr />TR(SUBSTR(<wbr />column1,IN<wbr />STR(column<wbr />1,'_'),'_'<wbr />)
</div>


Quite a few ways to do this. One, probably not the most efficient:
LEFT(SUBSTR(column1,INSTR(column1,'_'),LEN(column1)),INSTR(SUBSTR(column1,INSTR(column1,'_'),'_')

<div>
- angelll suggestion works perfect, thank you!. i've also try the other two however return error.<br />
<br />
OP
</div>


- angelll suggestion works perfect, thank you!. i've also try the other two however return error.

OP

<div>
<div class="content wysiwyg-content">
hi fellow experts,<br />
- i am working on a data conversion task and after 24hours of non-sleep, i'm unable to get my brain working on this. i have list of data as below in an Oracle table, and i need to extract the value in middle, in-between the two underscore '_'. the length can be vary: &nbsp; <br />
<br />
column1<br />
======================<br />
asbc134_123acd_2345-10 <br />
a655s_bgddg_as45-05 <br />
s5gg6a_bhb89hj_2f677-15 <br />
dds4rr4_19898sd_265ff-01 <br />
<br />
<br />
- expected result:<br />
column1<br />
======================<br />
123acd <br />
bgddg <br />
bhb89hj <br />
19898sd <br />
<br />
- any method is welcome either using regular expression or substr-instr...
</div>
</div>


hi fellow experts,
- i am working on a data conversion task and after 24hours of non-sleep, i'm unable to get my brain working on this. i have list of data as below in an Oracle table, and i need to extract the value in middle, in-between the two underscore '_'. the length can be vary:   

column1
======================
asbc134_123acd_2345-10 
a655s_bgddg_as45-05 
s5gg6a_bhb89hj_2f677-15 
dds4rr4_19898sd_265ff-01 


- expected result:
column1
======================
123acd 
bgddg 
bhb89hj 
19898sd 

- any method is welcome either using regular expression or substr-instr...

sql query to get value from a string

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.