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

What is the parameter mode that can be passed to a procedure?

1023

What is the relation of a user account and a schema?

1113

How to drop a tablespace?

1034

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2019

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2027

What are dml statements in oracle?

1082

What is recovery manager(rman) backup in Oracle?

1173

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1958

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3038

What is the recommended interval at which to run statspack snapshots, and why?

2901

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1059

How to write an inner join with the where clause in oracle?

1035

How to write a query with an inner join in oracle?

1024

What is a sub query? Describe its types?

1002

Is it possible to insert comments into sql statements return in the data model editor ?

2536