Oracle right characters

-- For Oracle only

-- syntax 
SUBSTR(<main-string>,-<number-of-characters>)

-- example 
SUBSTR('Useless stuff',-9) -- OUTPUT: ess stuff

-- practical example
SELECT SUBSTR('Useless stuff',-9)
FROM DUAL;

Similar codes

0 vote129 views1 answer
Mysql get last 2 month data
SQL
0 vote121 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
2 votes112 views1 answer
Mysql auto increment jumping
SQL
0 vote119 views1 answer
Use between operator in mysql
SQL
1 vote120 views4 answers
Postgres extract date from timestamp
SQL
0 vote126 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
2 votes117 views1 answer
Install sqlite npm
SQL
0 vote172 views1 answer
Drop view sql
SQL
0 vote128 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
2 votes113 views2 answers
Sql first character
SQL