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 votes132 views1 answer
Oracle show errors compilation
SQL
18 votes134 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote141 views1 answer
Populate db from command line postgres
SQL
2 votes214 views1 answer
Postgresql group by month and year
SQL
0 vote190 views1 answer
Selecting from a view SQL
SQL
0 vote141 views1 answer
Storing RGBA in mysql db
SQL
0 vote138 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote133 views1 answer
Différence entre deux dates sql oracle
SQL
1 vote158 views1 answer
Oracle user last connection date
SQL
5 votes143 views1 answer
Commentaire table oracle
SQL