String Functions: Instr

Description: Finds the first placement of a character or characters in a string.

SELECT INSTR ('Now is the time', 'w') FROM dual;
 
Returns - 3

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.