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

1 vote147 views1 answer
Primary key with prefix sql
SQL
8 votes136 views1 answer
Sql remove characters from string right
SQL
8 votes168 views1 answer
Mysql restore database
SQL
1 vote155 views1 answer
Postgresql contains
SQL
17 votes279 views4 answers
Show all tables in oracle
SQL
6 votes148 views3 answers
How to delete table sqlite
SQL
0 vote159 views1 answer
Datagrip go to line
SQL
0 vote146 views2 answers
Oracle create chain rule
SQL
16 votes157 views1 answer
CTE statement sql server
SQL
0 vote195 views1 answer
Mysql faster delete
SQL