skip to main | skip to sidebar

My first step in Writing

Monday, March 26, 2012

Count the occurence of a string in Oracle

WITH data AS (SELECT 'Whose line is it anyway' line FROM DUAL)
SELECT LENGTH(line)-LENGTH(TRANSLATE(line,'xaeiou','x')) nbVowels
FROM data;
Posted by KosmoData at 6:45 AM
Labels: Oracle String, String Functions

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2019 (1)
    • ►  October (1)
  • ►  2015 (1)
    • ►  April (1)
  • ►  2014 (5)
    • ►  December (1)
    • ►  November (3)
    • ►  January (1)
  • ►  2013 (2)
    • ►  October (2)
  • ▼  2012 (26)
    • ►  April (6)
    • ▼  March (7)
      • MERGE UPDATE
      • Update cascade Tom kyte Example (Programatic)
      • Oracle DBMS_SQL
      • identify the columns and data types in a Weakly Ty...
      • Translate & Replace Oracle
      • Count the occurence of a string in Oracle
      • Reference Cursor
    • ►  February (13)

About Me

KosmoData
View my complete profile