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

1 vote255 views1 answer
Oracle see column type
SQL
0 vote249 views1 answer
Sql to search who modified
SQL
0 vote162 views1 answer
Group_concat only returns one row
SQL
0 vote198 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote149 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
4 votes177 views1 answer
Adding data to table in sql python
SQL
2 votes193 views2 answers
Mysql does sentence contain word
SQL
0 vote192 views1 answer
Basic structure of sql expression having clause
SQL
5 votes211 views3 answers
Sql limit offset
SQL
0 vote159 views1 answer
Order by monthly in sql
SQL