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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Obtain only alphabets from table

Re: Obtain only alphabets from table

From: Alan <alan_at_erols.com>
Date: Wed, 30 Jun 2004 13:45:23 -0400
Message-ID: <2kgcgnF239smU1@uni-berlin.de>

"Reddy" <yyandapa_at_in.ibm.com> wrote in message news:b8d170a3.0406292216.703a9861_at_posting.google.com...
> There is a table name "testtable". This table has three columns
> col1(char), col2(int) and col3(char). The data in the table will be as
> mentioned below:
>
> ------------------------------------------
> Col1 Col2 Col3
> 0 0 0
> 1 1 1
> 2 2 2
> 3 3 3
> 4 4 4
> 5 5 5
> 6 6 6
> 7 7 7
> 8 8 8
> 9 9 9
> a 10 A
> A 11 A
> b 12 B
> B 13 B
> c 14 C
> C 15 C
> ------------------------------------------
>
> How can i get only the alphabets and not numerics from Col3 with the
> order by caluse on Col2?
>
> The result should be as follows:
> A
> B
> C
>
> Please help me out to obtain the result as mentioned above.
> Thanks in advance
>
> Thanks,
> Reddy

SELECT information
FROM textbook, classnotes
WHERE instructor = grader
AND student = learner
OR student_grade_will_be = 'F'
; Received on Wed Jun 30 2004 - 12:45:23 CDT

Original text of this message

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