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 vote152 views1 answer
Sql server select ignore dupplicates
SQL
0 vote152 views1 answer
Select last N rows mysql
SQL
0 vote142 views1 answer
Declare date variable sql
SQL
0 vote142 views1 answer
SQL column name Oracle
SQL
13 votes148 views4 answers
Mysql get last row
SQL
0 vote175 views1 answer
Edit shchima table in sql
SQL
4 votes154 views2 answers
Postgre sql create table
SQL
0 vote161 views3 answers
Magento 2 order delete from db
SQL
0 vote147 views1 answer
Postgresql where clause not working
SQL
7 votes145 views3 answers
Sql get last inserted row
SQL