ORACLE RIGHT TWO DIGITS

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

answer ORACLE RIGHT TWO DIGITS

related oracle sql two left digits

Comment

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

Popularity 3/10 Helpfulness 9/10 Language sql

Tags: digits oracle sql

Link to this answer
Share Copy Link

Contributed on Sep 08 2021

Trained Tuna

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

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

Popularity 1/10 Helpfulness 8/10 Language sql

Source: Grepper

Tags: oracle sql digits

Link to this answer
Share Copy Link

Contributed on May 25 2022

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.