Subtr Oracle ?

Oracle substring

-- ORACLE substr(string, start, [, length ])
SELECT substr('Hello World', 4, 5) FROM DUAL;       -- lo Wo
SELECT substr('Hello World', 4) FROM DUAL;          -- lo World
SELECT substr('Hello World', -3) FROM DUAL;         -- rld
SELECT substr('Hello World', -3, 2) FROM DUAL;      -- rl

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

13 votes216 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
2 votes287 views2 answers
Set value to null sql
SQL
0 vote231 views1 answer
Download sql file of countries names
SQL
11 votes215 views2 answers
Turn off safe mode mysql
SQL
12 votes247 views6 answers
How to install sqlite3 in python
SQL
1 vote314 views4 answers
Alter schema sql
SQL
0 vote190 views2 answers
Mysql create table if not exists
SQL
0 vote200 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote254 views1 answer
What is common table expression in sql
SQL
3 votes196 views2 answers
Mysql update row
SQL