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

-1 vote257 views1 answer
Difference berween database and data base management system
SQL
5 votes270 views1 answer
Oracle source query
SQL
0 vote212 views1 answer
Mysql max number not returning correct value
SQL
1 vote230 views2 answers
Get table column names sql laravel
SQL
0 vote203 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
14 votes232 views6 answers
Auto_increment mysql
SQL
0 vote183 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote222 views1 answer
Sql last time database was accessed
SQL
3 votes209 views3 answers
How to add month in update sql
SQL
2 votes270 views1 answer
Create delete procedure mysql
SQL