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 vote307 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote306 views1 answer
Exectuer myssql .sql
SQL
0 vote313 views1 answer
Mysql select random rows large table
SQL
0 vote315 views1 answer
How to update date value in sql
SQL
37 votes471 views3 answers
Sql check duplicate value in column
SQL
12 votes299 views4 answers
Import mysql database command line linux
SQL
0 vote290 views1 answer
Mysql table variables
SQL
-1 vote286 views2 answers
On update cascade
SQL
0 vote310 views2 answers
Faster mysql imports
SQL
1 vote291 views1 answer
Psql datetime grather than
SQL