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

2 votes355 views2 answers
Change varchar length mysql
SQL
0 vote426 views1 answer
Delete ids between sql
SQL
3 votes353 views2 answers
Mysql HAVING
SQL
0 vote365 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
1 vote399 views2 answers
Full join
SQL
15 votes386 views4 answers
Mysql where value is null
SQL
17 votes365 views6 answers
MySQL ORDER BY
SQL
0 vote364 views1 answer
10000000000000000000 am to meters
SQL
0 vote332 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote341 views1 answer
How to count with except in psql
SQL