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 votes220 views2 answers
How to get yesterday date in mysql
SQL
0 vote170 views1 answer
Sql case when exists in another table
SQL
5 votes201 views5 answers
Find max number in sql
SQL
0 vote181 views7 answers
10 random questions use python and SQL
SQL
0 vote163 views1 answer
Get number of rows in every table mysql
SQL
1 vote241 views2 answers
Intersect sql
SQL
8 votes187 views10 answers
Sql
SQL
0 vote183 views1 answer
Alter table change default
SQL
0 vote172 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote165 views1 answer
Postgres jsonb array push new element
SQL