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

13 votes140 views3 answers
List all the tables in sql
SQL
0 vote115 views1 answer
Multiple tricky query in sql server
SQL
38 votes168 views4 answers
Count sql
SQL
0 vote116 views1 answer
Drop CHECK constraint sql
SQL
0 vote107 views1 answer
Consecutive numbers sql
SQL
6 votes116 views1 answer
T-sql test if table exists
SQL
56 votes296 views5 answers
Psql create user
SQL
3 votes107 views2 answers
Postgresql remove not null constraint
SQL
-2 votes122 views2 answers
Union all in sql
SQL
5 votes109 views4 answers
Select random rows sql
SQL