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

1 vote85 views1 answer
Postgresql last element of array
SQL
0 vote99 views1 answer
Count char in java
SQL
27 votes138 views4 answers
Get all tables with column name sql
SQL
0 vote133 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
0 vote129 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote182 views1 answer
Sql server datetime
SQL
6 votes130 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
7 votes140 views3 answers
Postgre describe table
SQL
16 votes129 views4 answers
Sort by sql
SQL
12 votes136 views4 answers
How to take database dump in postgresql
SQL