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 vote210 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
7 votes149 views1 answer
Oracle set sequence value to max(id)
SQL
1 vote148 views1 answer
Local sql server
SQL
2 votes162 views2 answers
Postgres add column integer
SQL
-1 vote166 views1 answer
Count occurrences sql
SQL
5 votes147 views1 answer
Mysql add user with all privileges
SQL
22 votes201 views4 answers
Date format mysql
SQL
0 vote161 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote153 views2 answers
Mysql on update current_timestamp
SQL
0 vote196 views1 answer
Mariadb disable foreign key checks
SQL