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 vote308 views1 answer
Forcefully delete a row in mysql which has references
SQL
2 votes372 views2 answers
Set value to null sql
SQL
3 votes335 views2 answers
Oracle privileges users
SQL
0 vote322 views1 answer
How to combine rows in sql server procedure
SQL
0 vote326 views1 answer
Double in sql server example
SQL
1 vote318 views4 answers
Postgres extract date from timestamp
SQL
4 votes330 views1 answer
Mysql ip address data type
SQL
26 votes328 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote352 views1 answer
Sql server remove primary key without dropping table
SQL
3 votes317 views1 answer
Oracle revoke
SQL