oracle substring syntax

Solutions on MaxInterview for oracle substring syntax by the best coders in the world

Search
showing results for - "oracle substring syntax"
Valentino
17 Oct 2020
1-- ORACLE SQL - Get the 2 digits at the right end of a string
2SELECT SUBSTR('TN0001234567890345',-2) FROM DUAL;
3
4
source
similar questions
oracle string substitutionoracle sql substroracle list subpartitionsplsql substroracle column commenthow to use or values in oracleoracle leastoracle right charactersoracle character setoracle functionsubstring sqloracle find text in functionsoracle substringoracle function in outoracle leftmost charactersoracle sql wildcard likeoracle exchange subpartitionoracle simple quoteoracle table commentsubtr oracle 3fhow to know the character set of an oracle databesminus oracle exempleoracle split stringoracle ords parse
queries leading to this page
substr in oraclesubstring in oracle sqlhow to substring column in oracleoracle sql substringsubstr oraclehow to substring oracleoracle select substring 2b ou oracle substringoracle select substringoracle substroracle substring sqlsubsring in oracleoracle sql substroracle sql 3a substringdoes substring work in oracledoes substring work in oracle sqlsubstring oraclesubstring in sql oraclesub string oracleoracle substring syntax