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

8 votes361 views1 answer
My sql version
SQL
14 votes319 views2 answers
How to auto increment in sql
SQL
11 votes322 views2 answers
Import sql file laravel cmd
SQL
2 votes349 views4 answers
2nd highest salary in mysql
SQL
2 votes350 views2 answers
Change mysql password from command line
SQL
0 vote343 views1 answer
Mysql cast null to string
SQL
0 vote324 views4 answers
Sql year
SQL
17 votes397 views4 answers
Show all tables in oracle
SQL
0 vote349 views1 answer
Python list from sql
SQL
4 votes328 views3 answers
Oracle sql first day of quarter
SQL