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

3 votes319 views5 answers
Foreign keys
SQL
0 vote282 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote305 views1 answer
Oracle sql log to console
SQL
16 votes297 views6 answers
Insert sql
SQL
5 votes272 views1 answer
Postgres upsert
SQL
0 vote330 views2 answers
How to prevent sql injection in java
SQL
7 votes292 views2 answers
N highest salary in sql
SQL
0 vote404 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote307 views1 answer
Sql contains numeric characters
SQL
0 vote294 views1 answer
Mysql terminal list table
SQL