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 vote205 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
7 votes187 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote150 views1 answer
Flask_sqlalchemy install
SQL
1 vote200 views1 answer
Mysql month name extract
SQL
4 votes219 views4 answers
Mysql get date from datetime
SQL
5 votes189 views2 answers
Postgre insert select
SQL
6 votes181 views1 answer
Oracle trigger after logon on database
SQL
0 vote211 views1 answer
Select lowest values sql
SQL
0 vote232 views1 answer
Sql query tags
SQL
1 vote202 views2 answers
Mysql switch case
SQL