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 vote103 views1 answer
Sql count how many times a value appears
SQL
0 vote139 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote141 views1 answer
How to list function in psql
SQL
14 votes143 views4 answers
Sql compiler
SQL
0 vote131 views1 answer
How to stop all connections to a psql 12 database?
SQL
1 vote138 views3 answers
How to truncate foreign key constraint table
SQL
3 votes150 views5 answers
Sql select
SQL
5 votes148 views1 answer
Sort order on two columns sql
SQL
57 votes338 views6 answers
Mysql alter table add column
SQL
3 votes203 views1 answer
Apex call duration
SQL