Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Syntax from newbie

SQL Syntax from newbie

From: <MathewG.BettyG_at_gmail.com>
Date: 7 Feb 2007 12:54:05 -0800
Message-ID: <1170881644.621752.74180@h3g2000cwc.googlegroups.com> 





Need help, please



What is the correct syntax to get all rows that contain only letters
OR only numbers



ie: In a table Employee_addreess, the column 'zip' should contain
numeric values of zip codes. But I know there are alpha letters in
there. So i want to get a list of all the rows than might contain
alpha letters in there



Thanks in advance of the help.
Received on Wed Feb 07 2007 - 14:54:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US