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

9 votes253 views2 answers
Mysql change value
SQL
0 vote254 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote247 views1 answer
Select only one row sql
SQL
0 vote235 views1 answer
How to check replication lag in mySQL
SQL
3 votes254 views1 answer
Sql server version query
SQL
0 vote236 views1 answer
Mysql find non alphanumeric characters
SQL
1 vote248 views2 answers
Sql select only first occurrence
SQL
0 vote254 views1 answer
Count characters of string mysql
SQL
6 votes243 views2 answers
Return columns from table sql
SQL
6 votes260 views2 answers
Mysql get yesterday
SQL