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 vote197 views1 answer
MySql get primary keys of table
SQL
0 vote219 views2 answers
Reseed sql identity
SQL
0 vote217 views1 answer
Sqlalchemy empty table
SQL
0 vote165 views0 answer
How to connect to datbase in springboot
SQL
1 vote218 views1 answer
Update mysql centos
SQL
1 vote210 views1 answer
Oracle undo usage per session
SQL
8 votes161 views2 answers
Alter column name in mssql
SQL
2 votes207 views4 answers
2nd highest salary in mysql
SQL
1 vote182 views2 answers
Into sql
SQL
0 vote197 views1 answer
Renommer table sql
SQL