Oracle leftmost 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;

Subtr Oracle ?

/*Using SUBSTR in Oracle (Example from hackerrank.com): */

/*Simple select query...*/ 
SELECT DISTINCT city 
FROM station 

/*Using WHERE and SUBSTR to find (distinct) cities in station table that begin 
as well as end with a vowel.*/ 
WHERE SUBSTR(city,1,1) IN ('A','E','I','O','U') 
	AND substr(city,-1) IN ('a','e','i','o','u'); 

/*Parameters for SUBSTR (Substring) in order are as follows: 
String, Start, Length.*/

Source: hackerrank.com

Similar codes

0 vote186 views1 answer
Sqlite display headers on columns
SQL
2 votes117 views1 answer
How to delete columns in sql
SQL
1 vote121 views1 answer
Mysql drop key
SQL
0 vote134 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
2 votes146 views1 answer
Oracle apex who is connected
SQL
1 vote130 views2 answers
Pad zero sql server
SQL
0 vote136 views1 answer
Mysql query problems and solutions
SQL
-1 vote164 views3 answers
SQL MM/dd/yyyy format
SQL
3 votes121 views1 answer
Oracle user quota unlimited
SQL
1 vote161 views1 answer
Drop colum oracle 18c
SQL