Return to Snippet

Revision: 71053
at December 16, 2016 04:58 by bbrumm


Initial Code
/*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;

Initial URL
http://www.databasestar.com/oracle-instr/

Initial Description
A few examples of the Oracle INSTR function.

Initial Title
Oracle INSTR Function

Initial Tags
sql, Oracle

Initial Language
SQL