skip to main | skip to sidebar

ORACLE APPS

ORACLE APPS TECHNICAL CONCEPTS

Thursday, April 12, 2012

SQL to find special character records in a table

select city from hz_locations where regexp_like(city,chr(15712189));
Posted by Rajesh Chigullapalli at 9:05 AM

No comments:

Post a Comment

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

Blog Archive

  • ►  2019 (1)
    • ►  September (1)
  • ►  2017 (3)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2016 (5)
    • ►  May (3)
    • ►  March (2)
  • ►  2014 (12)
    • ►  December (1)
    • ►  November (1)
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  April (4)
    • ►  February (1)
    • ►  January (2)
  • ►  2013 (20)
    • ►  December (3)
    • ►  November (1)
    • ►  September (3)
    • ►  August (2)
    • ►  July (8)
    • ►  June (1)
    • ►  March (2)
  • ▼  2012 (36)
    • ►  November (2)
    • ►  October (9)
    • ►  September (2)
    • ►  August (2)
    • ►  July (4)
    • ►  June (6)
    • ►  May (6)
    • ▼  April (4)
      • Program - Publish FSG Report custom template will ...
      • Record has been updated. Requery block to see change
      • SQL to find special character records in a table
      • R12 changes in JA Tables
    • ►  March (1)
  • ►  2011 (3)
    • ►  February (3)
  • ►  2010 (14)
    • ►  September (1)
    • ►  July (2)
    • ►  June (1)
    • ►  May (6)
    • ►  April (3)
    • ►  March (1)
  • ►  2009 (2)
    • ►  May (1)
    • ►  April (1)
  • ►  2008 (4)
    • ►  May (2)
    • ►  April (2)

About Me

Rajesh Chigullapalli
View my complete profile