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 vote383 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote327 views1 answer
Update and replace mysql
SQL
2 votes357 views2 answers
Sql query to list all tables in a database sql server
SQL
8 votes343 views2 answers
Sqlsrv default port
SQL
0 vote349 views1 answer
Sql change column in existing table
SQL
2 votes353 views2 answers
Mysql count rows returned
SQL
1 vote347 views1 answer
Pgsql sum switch case
SQL
3 votes297 views1 answer
If 0 return null else return query mysql
SQL
0 vote321 views1 answer
Optimize sql query
SQL
14 votes340 views1 answer
Sql value of string
SQL