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 vote306 views1 answer
How to check default value of column in sql server
SQL
2 votes352 views2 answers
Postgres change owner of schema
SQL
1 vote311 views1 answer
Sql select contem uma palavra
SQL
1 vote315 views1 answer
Drop df constraint sql server
SQL
0 vote342 views1 answer
Neo4j command to run script file
SQL
0 vote293 views1 answer
Sqldf change user
SQL
6 votes334 views1 answer
How to get the size of the database in postgresql
SQL
1 vote326 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote307 views1 answer
Use between operator in mysql
SQL
0 vote305 views1 answer
Oracle show running job
SQL