Oracle character index

-- EXAMPLE
select 
	'0004V0' as TESTER
	, INSTR('0004V0','V') -- OUTPUT: 5
	, INSTR('0004V0','0') -- OUTPUT: 1
	, INSTR('0004V0','0',4) -- OUTPUT: 6
from DUAL;

-- SYNTAX
INSTR(/*Main string*/, /*substring*/, /*start index*/)

Similar codes

0 vote353 views1 answer
Commit transaction sql
SQL
0 vote355 views1 answer
A network or instance-specific error sql server
SQL
0 vote344 views1 answer
Sql create table with references not primary key
SQL
0 vote370 views1 answer
Sql server set complex constraints
SQL
0 vote350 views1 answer
Display first three characters sql
SQL
1 vote350 views2 answers
String to date postgres
SQL
0 vote344 views1 answer
Original Query
SQL
0 vote344 views1 answer
Mysql workbench not showing schemas
SQL
0 vote361 views1 answer
WHERE not regex in SQL
SQL
0 vote357 views1 answer
Export partttion and import in oracle
SQL