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 vote332 views1 answer
How to use sqlcommand
SQL
-1 vote264 views2 answers
On delete set default sql server
SQL
2 votes284 views2 answers
How to view created temporary tables in mysql
SQL
1 vote303 views1 answer
Oracle sequence last_number
SQL
0 vote299 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote302 views2 answers
Create row number in sql
SQL
4 votes312 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote273 views1 answer
Ffeathers express mysql application users login
SQL
0 vote293 views1 answer
Select from column mysql
SQL
0 vote286 views1 answer
MySQL - How to find word with the most similar beginning
SQL