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 vote207 views2 answers
How covert into int in maria db
SQL
0 vote218 views1 answer
Get the next column of a table in mysql
SQL
1 vote196 views1 answer
What is intersect
SQL
8 votes188 views2 answers
Phpmyadmin default password
SQL
0 vote195 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote211 views1 answer
Dump only data
SQL
8 votes205 views1 answer
Sql limit results returned
SQL
2 votes184 views1 answer
Mysql select random id from table
SQL
0 vote193 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
2 votes209 views1 answer
Create mysql user on all hosts
SQL