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

6 votes174 views2 answers
Difference between join vs union
SQL
1 vote163 views1 answer
Mysql stop password policy
SQL
0 vote179 views2 answers
How to create a table from another table in sql derby
SQL
0 vote160 views1 answer
Raiserror nowait sql server
SQL
0 vote156 views1 answer
Sql random decimal
SQL
0 vote207 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote186 views1 answer
Ansi sql count duplicate rows
SQL
0 vote158 views1 answer
Postgresql array to rows
SQL
0 vote197 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote159 views1 answer
Print intervals of 15 minutes in sql query
SQL