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
4807 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

Why is oracle used?

939

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1051

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1068

What is a nvl function?

1034

How to connect to the server with user account: sys?

1022

What are the differences between date and timestamp in oracle?

1047

How to write numeric literals in oracle?

1184

Explain what are clusters?

1109

What suggestions do you have to reduce the network traffic?

962

Define oracle database

1045

Is there any function in oracle similar like group_concat of mysql?

1053

What is the Tune Query

2292

What do you understand by database schema and what does it hold?

1230

What is the difference between Delete, Truncate and Drop in Oracle?

1131

Explain cascading triggers.

1074