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 vote267 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
2 votes267 views2 answers
Checking data type in sql server
SQL
5 votes284 views3 answers
Mysql remove unique constraint
SQL
0 vote228 views1 answer
Expose db in virtualbox
SQL
0 vote286 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote308 views1 answer
Pgadmin check database
SQL
0 vote219 views1 answer
Denied
SQL
0 vote268 views1 answer
Mysql date minus 1 day
SQL
0 vote289 views1 answer
SQL FROM-Klausel
SQL
5 votes268 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL