select * from PA_TASKS pp where pp.TASK_NUMBER in (select QQ.TASK

how to select alphabets in a one column , for this the
table name is PA_TASKS and column name is TASK_NUMBER, In
TASK_NUMBER the data like this
1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For
this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE,
Its some urgent requirement ,thanks in advance

Question Posted / vinay singh

6 Answers
10482 Views
I also Faced
E-Mail Answers

Answer Posted / vinay singh

select * from PA_TASKS pp
where pp.TASK_NUMBER in
(select QQ.TASK_NUMBER from PA_TASKS QQ
where length(trim(translate
(QQ.TASK_NUMBER,'0123456789',' '))) > 0
)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is transaction control language (tcl)?

1142

What does the hierarchical profiler does?

1065

Explain the purpose of %type and %rowtype data types?

935

Can we create view in stored procedure?

981

What is fmtonly in sql?

1090

What is the use of prepared statement?

1029

What is the best free sql database?

1058

Explain the uses of control file.

1051

What are the operators used in select statements?

1059

What is a table?

1022

What are all the different normalization?

1045

What is normalisation in sql?

1066

How does an execution block start and end in pl sql?

957

Which command is used to delete a trigger?

1337

What is the most restrictive isolation level? : Transact sql

1087