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

3 votes224 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote229 views1 answer
Oracle show running job
SQL
0 vote219 views1 answer
Uncomment listen_address=localhost
SQL
13 votes235 views2 answers
Oracle select into and inner join
SQL
1 vote222 views1 answer
Oracle split string
SQL
0 vote231 views1 answer
Login failed for user sql server
SQL
44 votes238 views6 answers
Rename command in sql
SQL
0 vote292 views1 answer
Php insert null mysql
SQL
3 votes212 views1 answer
Oracle detect invalid password
SQL
3 votes204 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL