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

4 votes294 views1 answer
Add constraint fk
SQL
0 vote304 views1 answer
Sql server check whether column has same equal values
SQL
0 vote300 views1 answer
Subquery aggregation
SQL
0 vote300 views1 answer
Sql date d'aujourd'hui
SQL
5 votes290 views1 answer
How to check port number for postgresql
SQL
0 vote292 views1 answer
Alter table fulltext
SQL
2 votes262 views1 answer
Foreign key example in dbms
SQL
2 votes298 views1 answer
Laravel sql String
SQL
1 vote292 views1 answer
Sql run multiple updates in one query
SQL
12 votes294 views5 answers
Sql merge
SQL