If the INSTR pattern is not found, then the entire string would be returned : INSTR « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. INSTR

If the INSTR pattern is not found, then the entire string would be returned

 

SQL>
SQL> -- If the INSTR pattern is not found, then the entire string would be returned
SQL>
SQL> SELECT SUBSTR('aaa bbb c', INSTR('aaa bbb c','zonk')) FROM dual;

SUBSTR('A
---------
aaa bbb c








Related examples in the same category

1.INSTR: returns the first-occurrence position of a character within a string
2.Simple demo for INSTR function: returns a location within the string where search pattern begins
3.INSTR: Look for the second occurrence of 'is'
4.If search pattern is not in the string, the INSTR function returns 0
5.Combine INSTR and SUBSTR together
6.Get the sub string position by using instr
7.use instr in an if statement in PL SQL
8.Ise INSTR to format a column
9.split column value with ','
10.Use substr and instr to extract column value
11.instr and substr