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 vote282 views2 answers
Sqlite unique
SQL
1 vote274 views1 answer
Get table which have specific columns in mysql
SQL
0 vote278 views1 answer
How to find sql server name
SQL
1 vote302 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote268 views1 answer
Update set with inner join oracle
SQL
2 votes283 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote267 views1 answer
1 column values in to 1 single row in sql
SQL
5 votes286 views4 answers
Change auto increment mysql
SQL
0 vote299 views1 answer
Shrink database file in sql server
SQL
1 vote268 views1 answer
How to truncate a table in databse
SQL