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

11 votes222 views2 answers
Having clause
SQL
3 votes225 views1 answer
Sql timestamp to date
SQL
-1 vote236 views1 answer
Sql set max value in column
SQL
0 vote242 views1 answer
Convert polygon to text in mysql
SQL
0 vote259 views1 answer
Move table to a different schema
SQL
17 votes231 views5 answers
Order by sql
SQL
4 votes228 views1 answer
Mysql ip address
SQL
0 vote239 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
9 votes261 views2 answers
SELECT User,Host FROM mysql.user;
SQL
0 vote230 views1 answer
Oracle job session
SQL