SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL/PLSQL Question on INSTR function

RameshSagarSep 24 2019 — edited Oct 1 2019

Hi All,

Can someone explain me the below logic/code step-by-step?

VAR_LANID = 'Admin'

            IF INSTR('\',VAR_LANID,1) > 0 THEN
    VAR_LANID:=SUBSTR(VAR_LANID,INSTR('\',VAR_LANID,1)+1,LENGTH(VAR_LANID)-INSTR('\',VAR_LANID,1));
   END IF;

Thanks in advance.

Regards

Ramesh

Added on Sep 24 2019

18 comments

1,279 views