CoderZone.org

Category: >> Oracle PL/SQL >> INSTR (InString) Bookmark and Share

<< lastnext >>

Snippet Name: INSTR (InString)

Description: The instr function returns the location of a substring in a string.

If string2 is not found in string1, then the instr Oracle function will return 0.

Also see:
» FUNCTIONS: Deterministic
» FUNCTIONS: Nested Functions
» FUNCTIONS: IF statement
» FUNCTIONS: date/time
» FUNCTIONS: Sample functions
» FUNCTIONS: drop
» FUNCTIONS: Recompile
» FUNCTIONS: DEBUG mode
» FUNCTIONS: IN OUT parameter
» FUNCTIONS: with output parameters
» FUNCTIONS: with parameters
» FUNCTIONS: without parameters
» FUNCTIONS: Create function
» FUNCTIONS: special restrictions
» FUNCTIONS: System Privileges
» IN Function
» Built-In Functions: CASE
» Built-In Functions: DECODE
» SUBST and INSTR together
» SUBSTR (SubString)
» String Functions: REVERSE
» String Functions: LENGTH
» String Functions: INSTR
» String Functions: CONCAT
» String Functions: CHAR
» String Functions: INITCAP
» String Functions: LOWER
» String Functions: UPPER
» Date Functions: NUMTOYMINTERVAL
» Date Functions: NUMTODSINTERVAL

Comment: (none)

Author: CoderZone
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 05th, 2009

INSTR( string1, string2 [, start_position [, nth_appearance ] ] )
 
-- string1 is the string to search.
 
-- string2 is the substring to search for in string1.
 
-- start_position is the position in string1 where the search 
-- will start. This argument is optional. If omitted, it defaults 
-- to 1. The first position in the string is 1. If the start_position 
-- is negative, the function counts back start_position number 
-- of characters from the end of string1 and then searches towards 
-- the beginning of string1.
 
-- nth_appearance is the nth appearance of string2. This is 
-- optional. If omitted, it defaults to 1.
 
-- Examples: 
INSTR('sqluniversity', 'i')  -- would return 6; the first occurrence of 'i'
INSTR('sqluniversity', 'i', 1, 1) -- would return 6; the first occurrence of 'i'
INSTR('sqluniversity', 'i', 1, 2) -- would return 11; the second occurrence of 'i'
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 6