Posted By

bbrumm on 12/16/16

Tagged

sql
Oracle

Versions (?)

Last Edited at 12/16/16 04:58am

Statistics

Viewed 799 times

Favorited by 0 user(s)

Related snippets

Oracle INSTR Function

/ Published in: SQL

A few examples of the Oracle INSTR function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

/*INSTR*/
 
/*Example 1*/
SELECT INSTR('Melbourne, Australia', 'e') FROM DUAL;
 
/*Example 2*/
SELECT INSTR('Melbourne, Australia', 'm') FROM DUAL;
 
/*Example 3*/
SELECT INSTR('Melbourne, Australia', 'M') FROM DUAL;
 
/*Example 4*/
SELECT INSTR('Melbourne, Australia', 'e', 1, 2) FROM DUAL;
 
/*Example 5*/	
SELECT INSTR('Melbourne, Australia', 'e', 5, 1) FROM DUAL;
 
/*Example 6*/
SELECT INSTR('Melbourne, Australia', 'e', 5, 2) FROM DUAL;
 
/*Example 7*/
SELECT INSTR('Melbourne, Australia', 'bou') FROM DUAL;
 
/*Example 8*/
SELECT INSTR('Melbourne, Australia', 'a', -1) FROM DUAL;
 
/*Example 9*/
SELECT INSTR('Melbourne, Australia', 'a', -1, 2) FROM DUAL;