SELECT CASE WHEN instr(TASK_NUMBER,'NN')>0 THEN 'NN'

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 only NN,but not other
alphabets, if NN is thre means i should display , otherwise
leave that blank or empty Its some urgent
requirement ,thanks in advance

Question Posted / reddibasha

2 Answers
4675 Views
I also Faced
E-Mail Answers

Answer Posted / reddibasha

SELECT CASE WHEN instr(TASK_NUMBER,'NN')>0 THEN 'NN' ELSE
null END FROM PA_TASKS;

Is This Answer Correct ?

8 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I connect to oracle?

974

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2092

How can I combine multiple rows into a comma-delimited list in oracle?

998

what is the use of system.effective.date variable in oracle?

1051

What is data file?

1040

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2899

What happens in oracle commit?

969

How to call a sub procedure?

1034

How to use group functions in the select clause using oracle?

1020

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1848

Explain a private synonyms?

980

Who developed oracle & when?

937

What is difference between cartesian join and cross join?

1014

How do I find my oracle client driver version?

969

In which language oracle has been developed?

1013