Advanced Search

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