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 vote356 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote350 views1 answer
Get number of rows in every table mysql
SQL
0 vote364 views1 answer
Resullt all update knex mysql
SQL
0 vote374 views1 answer
Set column in all row mysql
SQL
0 vote368 views1 answer
Code to move ietms from one table to another myswl
SQL
0 vote349 views1 answer
Mysql cdn link
SQL
0 vote341 views1 answer
Oracle search columns in schema
SQL
0 vote382 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
6 votes359 views1 answer
Oracle trigger after logon on schema
SQL
0 vote353 views1 answer
Copy Table from SQL to CSV
SQL