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 vote333 views1 answer
How to to get time in sql
SQL
24 votes348 views5 answers
List mysql users
SQL
0 vote304 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote346 views1 answer
Table user postgres
SQL
0 vote311 views1 answer
Oracle index hint
SQL
0 vote346 views1 answer
Migration graphql
SQL
0 vote321 views1 answer
How to check xampp mysql password
SQL
0 vote352 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote404 views1 answer
How to check common records in 2 table
SQL
5 votes330 views2 answers
Postgre insert select
SQL