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 vote97 views1 answer
Check sql database table lock
SQL
3 votes118 views3 answers
Restart mysql mac
SQL
0 vote110 views1 answer
Mysql backup certain tables workbench
SQL
1 vote101 views1 answer
Sql update table remove spaces
SQL
0 vote97 views1 answer
Mysql select statement after index
SQL
0 vote102 views2 answers
Plsql regex match whole word
SQL
3 votes109 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote120 views1 answer
Mysql aspas simples
SQL
10 votes106 views2 answers
Sql rtrim
SQL
0 vote100 views1 answer
Remove default constraint sql server
SQL