ORACLE PARSE STRING

Trained Tuna answered on September 8, 2021 Popularity 10/10 Helpfulness 1/10

answer ORACLE PARSE STRING

Comment

-1

-- ORACLE SQL - Get the 2 digits at the right end of a string
SELECT SUBSTR('TN0001234567890345',-2) FROM DUAL;

Popularity 10/10 Helpfulness 1/10 Language sql

Tags: oracle sql string substring syntax

Link to this answer
Share Copy Link

Contributed on Sep 08 2021

Trained Tuna

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.