Discussion in 'SQL PL/SQL' started by firstname.lastname@example.org, Dec 24, 2012.
how to display the last two charcters in a string? please give me rly
Re: HI Oracle Members
Post your code in the PL/SQL section to get help.
Moved the post to SQL PL/SQL section.
here is an example to get last two characters in a string.
SQL> SELECT SUBSTR('ThisIsClubOracle',-2,2)Result from dual;
Note: - You can use table columns also in the place of string in substr function.
For more examples please have a look into the following site.