Retreiving specific content in a Database table field
I require a solution:
I have a large database storing among many things GPS codes. The codes are in 7 digits. However users have been entering less or more than seven digits worse still some have entered letters and spaces. I need a query that can pull only such erroneous records for editing. Using length() function i have been able to deal with the less or more than 7 digits however i am no seeking a solution for checking whether letter have been entered.
Thanks in advance
Subject
Views
Written By
Posted
Retreiving specific content in a Database table field
3765
June 28, 2010 11:19AM
1632
July 01, 2010 11:38PM
1497
July 02, 2010 08:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.