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 votes362 views2 answers
Mamp connect mysql terminal
SQL
1 vote368 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
8 votes364 views1 answer
Check mysql version phpmyadmin
SQL
2 votes341 views2 answers
Mysql date range
SQL
10 votes372 views2 answers
Oracle alter sequence nextval
SQL
9 votes350 views5 answers
Sql limit
SQL
0 vote380 views1 answer
Order child below the parent in mysqli
SQL
1 vote380 views2 answers
Mysql update LAST_INSERT_ID()
SQL
1 vote397 views1 answer
Postgresql if 0 then 1
SQL
6 votes418 views2 answers
Oracle undotbs usage
SQL