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

2 votes191 views1 answer
Select * from table where name like
SQL
3 votes169 views1 answer
MySQL DELETE JOIN
SQL
2 votes138 views1 answer
Foreign key example in dbms
SQL
1 vote243 views1 answer
Drop column if exists sql server
SQL
0 vote229 views1 answer
Select multiple row from primary key sql
SQL
10 votes285 views2 answers
Doublon sql
SQL
0 vote209 views1 answer
.sql File Run in PSQL
SQL
1 vote201 views2 answers
End mysql command
SQL
1 vote278 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote186 views1 answer
ORA-13717
SQL