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 vote122 views1 answer
Sql on-premises
SQL
0 vote127 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote119 views2 answers
Sql drop view if exists
SQL
1 vote118 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote110 views2 answers
Close external port 3306 with iptables
SQL
13 votes122 views1 answer
Select count of distinct values sql
SQL
8 votes134 views2 answers
Update sql server from another table
SQL
0 vote113 views1 answer
Where in clause tsql
SQL
0 vote110 views1 answer
User defined variables in sql
SQL
28 votes123 views6 answers
Sql update
SQL