<div>
You can do it with regular expressions but those are expensive calls.<br />
<br />
I would use SUBSTR and INSTR. &nbsp;It will likely be faster:<br />
select substr('OPS$BCTGTWDOM\SMAN<wbr />AVI',instr<wbr />('OPS$BCTG<wbr />TWDOM\SMAN<wbr />AVI','\')+<wbr />1) from dual;<br />
<br />
that was hard-coded. &nbsp;I assume you have it in a table?<br />
select substr(yourcolumn,instr(yo<wbr />urcolumn,'<wbr />\')+1) from yourtable;
</div>


You can do it with regular expressions but those are expensive calls.

I would use SUBSTR and INSTR.  It will likely be faster:
select substr('OPS$BCTGTWDOM\SMANAVI',instr('OPS$BCTGTWDOM\SMANAVI','\')+1) from dual;

that was hard-coded.  I assume you have it in a table?
select substr(yourcolumn,instr(yourcolumn,'\')+1) from yourtable;

<div>
Someone will post it so here is the regexp_substr:<br />
select regexp_substr('OPS$BCTGTWD<wbr />OM\SMANAVI<wbr />','[^\]+$'<wbr />) from dual;
</div>


Someone will post it so here is the regexp_substr:
select regexp_substr('OPS$BCTGTWDOM\SMANAVI','[^\]+$') from dual;

<div>
why use regexp where INSTR and SUBSTR will do this as well (and more efficiently)?<br />
if you only need to identify the backslash and then clip out the text which follows it, regexp is a sledgehammer to crack a nut.
</div>


why use regexp where INSTR and SUBSTR will do this as well (and more efficiently)?
if you only need to identify the backslash and then clip out the text which follows it, regexp is a sledgehammer to crack a nut.

<div>
<div class="content wysiwyg-content">
Using Oracl regular expressions I want to extract character after the \ <br />
<br />
'OPS$BCTGTWDOM\SMANAVI' &nbsp; &nbsp; Output =&gt; SMANAVI <br />
<br />
How can I do this? <br />
<br />
Thanks
</div>
</div>


Using Oracl regular expressions I want to extract character after the \ 

'OPS$BCTGTWDOM\SMANAVI'     Output => SMANAVI 

How can I do this? 

Thanks

Oracle regular expression

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.

Regular Expressions

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.