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 vote148 views2 answers
Sql trigger difference between for and after
SQL
150 votes329 views10 answers
Grepper
SQL
0 vote233 views1 answer
Run mysql xampp shell
SQL
2 votes161 views1 answer
Column names in oracle sql
SQL
0 vote93 views1 answer
Mssql view column data type
SQL
0 vote142 views1 answer
T-sql update table variale
SQL
-1 vote134 views3 answers
Check table exist postgresql
SQL
0 vote157 views1 answer
Php select data from mysql database without column name
SQL
0 vote217 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote125 views1 answer
Materialized view redshift
SQL