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

0 vote241 views1 answer
Sql decimal to 2 places
SQL
0 vote217 views1 answer
Transaction and commit trong sql server
SQL
5 votes180 views1 answer
Postgresql functions
SQL
8 votes226 views2 answers
Sqlsrv default port
SQL
3 votes219 views3 answers
Order by postgres
SQL
0 vote233 views3 answers
Sql parenthetical expression examples
SQL
3 votes186 views1 answer
Mysql set field unique
SQL
0 vote229 views2 answers
SQL BULK INSERT
SQL
0 vote198 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote174 views1 answer
Show specific events on mysql
SQL