oracle right characters

Solutions on MaxInterview for oracle right characters by the best coders in the world

Search
showing results for - "oracle right characters"
Simona
26 Feb 2019
1-- For Oracle only
2
3-- syntax 
4SUBSTR(<main-string>,-<number-of-characters>)
5
6-- example 
7SUBSTR('Useless stuff',-9) -- OUTPUT: ess stuff
8
9-- practical example
10SELECT SUBSTR('Useless stuff',-9)
11FROM DUAL;
similar questions
oracle wildcardoracle column commentoracle right two digitsoracle table statisticsoracle leastoracle last character of stringvarchar2 length in oracleoracle character setoracle functionoracle string lengthoracle character indexoracle substringoracle leftmost charactersoracle function in outsubtr oracle 3foracle current sequence valueoracle simple quoteoracle table commentnon equal join in oracleoraclehow to know the character set of an oracle databesoracle substring syntaxminus oracle exempleoracle last connexionoracle nls charactersetoracle count characters in string
queries leading to this page
right in sqlsubstring in oracllesql developer substringsql rightoracle sbstroracle right charactersright in sqlpl sql substrleft function in sql developeroracle sql substring leftoracle substring 1st char from rightsubstring oracle 28substr oracle from endsubstring oracle queryhow to substring string in oracleoracle substringsubstring limit length oraclesql left charactersleft in oracleoracle rightmost charactersoracle tsql equivalent of rightoracle sql substring from backsubstr method in oraclesubstring oracle sqlsubstring of a number in oraclesubstr from a field value oracleoracel substroracle sql right functionoracle right1 characterright in oraclesubstring oracleoracle sql query substringsql right 4 charactersoracle substring rightoracle right characters