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

18 votes132 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote117 views1 answer
Show function mysql
SQL
0 vote131 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote120 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote130 views1 answer
Convert multiple columns to ROws in sql server
SQL
2 votes112 views1 answer
Sql update from different table
SQL
0 vote114 views1 answer
Sql find leading space
SQL
1 vote143 views1 answer
Sql server loop over query
SQL
1 vote165 views1 answer
Delete mysql ubuntu 20.04
SQL
3 votes107 views2 answers
Sql end of month
SQL