DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Finding Data with Trailing Whitespaces using Oracle SQL

  1. 07-17-2007, 06:31 AM #1
    dksuresh
    dksuresh is offline Junior Member
    Join Date
    Apr 2002
    Posts
    41

    Finding Data with Trailing Whitespaces using Oracle SQL

    I have a table SEQ_TIER_CODES.This table has a column MACHINE_TYPE.This column has records with values

    'EB417US'
    and
    'EB417US ' (ie value with trailing whitespaces)

    I would like to pick those records with the value 'EB417US ' (ie value with trailing whitespaces) using an Oracle SQL statement.Kindly help
    Reply With Quote Reply With Quote
  2. 07-17-2007, 07:39 AM #2
    slimdave
    slimdave is offline Foreign Script Kiddie
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Code:
    ... where machine_code like '% '
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE
    Reply With Quote Reply With Quote
  3. 07-17-2007, 07:39 AM #3
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    MACHINE_TYPE, is it VARCHAR2() or CHAR()
    SEQ_TIER_CODES, are values expected to have seven significant characters?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  4. 07-17-2007, 09:22 AM #4
    dksuresh
    dksuresh is offline Junior Member
    Join Date
    Apr 2002
    Posts
    41
    The datatype is VARCHAR2()
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width