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

13 votes173 views6 answers
Current date sql
SQL
0 vote255 views1 answer
Delet all record statment sql
SQL
0 vote164 views1 answer
Online sql testing tool
SQL
4 votes173 views2 answers
Oracle unlock user
SQL
10 votes176 views4 answers
Primary key sql
SQL
2 votes180 views1 answer
How to make insert script from table in SQL server
SQL
0 vote212 views1 answer
Automated psql csv export script on windows
SQL
0 vote176 views1 answer
Qt qsql check if table exist
SQL
0 vote198 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote197 views1 answer
Ubuntu stop mysql from starting on boot
SQL