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 vote190 views1 answer
Run mysql xampp shell
SQL
0 vote216 views1 answer
How to change mysql root password in windows 10
SQL
0 vote183 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
-1 vote153 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
0 vote194 views1 answer
Mysql remove bad character from all fields
SQL
6 votes201 views2 answers
Mysqldump password in file
SQL
1 vote206 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote220 views1 answer
Python dictionary to sql update
SQL
0 vote174 views1 answer
Convert sql server guid to varbinary
SQL
11 votes177 views3 answers
Sqlite3 create table from another table
SQL