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 vote215 views1 answer
Check if due date is less than todays date sql
SQL
1 vote275 views1 answer
Mysql list bigger table
SQL
9 votes253 views2 answers
Oracle all tables in schema
SQL
3 votes257 views2 answers
Coalesce mysql
SQL
4 votes274 views6 answers
Second max salary in sql
SQL
0 vote259 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
-1 vote268 views1 answer
Condition in orderby mysql
SQL
4 votes259 views2 answers
Mysql show indexes on table
SQL
0 vote256 views1 answer
Mysql update privileges
SQL
0 vote285 views1 answer
Command to give readonly access to a postgres sql user
SQL