Revision as of 14:19, 16 July 2012

SUBSTRING

SUBSTRING allows you to extract part of a string.

   SUBSTRING('Hello world', 2, 3) -> 'llo'

SELECT name,
       SUBSTR(name, 2, 5)
  FROM bbc

SELECT name,
       SUBSTRING(name, 2, 5)
  FROM bbc

@@ Line 17: / Line 17: @@
 <div class='ht'>
-In this example you put the region and the name together for each country.
 <source lang='sql' class='def e-oracle'>
 SELECT name,