Differences

This shows you the differences between two versions of the page.

Link to this comparison view

dev:sql:functions:instr [2016/06/28 22:38] (current)
Line 1: Line 1:
 +{{{page>:top_add&nofooter&noeditbtn}}
 +<html><div align="center"><span style="color:red">DRAFT</span></div></html>
 +====== Omnidex SQL Function: INSTR ======
 +{{page>:sql_bar&nofooter&noeditbtn}}
 +^See Also:^ [[ dev:sql:orafunctions:chr | CHR ]] ^ [[ dev:sql:orafunctions:instr | INSTR ]] ^ [[ dev:sql:orafunctions:new_time | NEW_TIME ]] ^ [[ dev:sql:orafunctions:nvl | NVL ]] ^ [[ dev:sql:orafunctions:substr | SUBSTR ]] ^ [[ dev:sql:orafunctions:sys_extract_utc | SYS_EXTRACT_UTC ]] ^ [[ dev:sql:orafunctions:sysdate | SYSDATE ]] ^ [[ dev:sql:orafunctions:systimestamp | SYSTIMESTAMP ]] ^ [[ dev:sql:orafunctions:to_date | TO_DATE ]] ^ [[ dev:sql:orafunctions:to_number | TO_NUMBER ]] ^
  
 +===== Description =====
 +The INSTR function returns an integer value representing the starting position of a string within the search string.
 +
 +This function is only available when the CREATE ENVIRONMENT statement contains the SQL_SYNTAX ORACLE clause or the SET SQL_SYNTAX ORACLE setting is set programmatically.
 +===== Syntax =====
 +  Syntax: INSTR(target_string, search_string[, start_position[, occurrence]])
 +
 +===== Discussion =====
 +==== target_string ====
 +//Target_string// is a character expression of either a column_spec or a collection of functions that return a string.
 +==== search_string ====
 +//Search_string// is a character expression of either a column_spec or a collection of functions that return a string.
 +==== start_position ====
 +//Start_position// is an optional integer expression that indicates that the all characters previous to the start_position should be ignored. 
 +==== occurrence ====
 +//Occurrence// is an optional integer expression that indicates to return character position of the nth occurrence of the search_string.
 +===== Examples =====
 +
 +   select instr('12345','3') from $omnidex;
 +
 +Returns a value of 3
 + 
 +   select instr('1234512345','3',4) from $omnidex;
 +
 +Returns a value of 8.
 +
 +   select instr('1234512345','3',1,2) from $omnidex;
 +
 +Returns a value of 8.
 +{{page>:bottom_add&nofooter&noeditbtn}}
 
Back to top
dev/sql/functions/instr.txt ยท Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0