Sql left characters

-- For Oracle only

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

-- example 
SUBSTR('Useless stuff',1,10) -- OUTPUT: Useless st

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

Sql 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 vote344 views1 answer
SQL authentication error
SQL
3 votes331 views1 answer
Select without null values sql
SQL
2 votes407 views3 answers
Sql delete duplicate
SQL
0 vote343 views1 answer
Search starting with mysql
SQL
0 vote356 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote377 views1 answer
Acutal month year
SQL
1 vote335 views2 answers
Login to mysql
SQL
1 vote335 views1 answer
Psql autocomplete for mac brew install
SQL
10 votes359 views2 answers
Oracle alter sequence nextval
SQL
3 votes329 views1 answer
Mysql load sql from file
SQL