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

Can we connect to ORACLE db using Windows Authentication?

1308

What is the simplest tool to run commands on oracle servers?

1052

What to do if the binary spfile is wrong for the default instance?

1107

Can we commit inside a function in oracle?

1012

What are the uses of a database trigger?

1036

How many types of tables supported by oracle?

1118

What are the varoius components of physical database structure of oracle database?

1040

What are the various oracle database objects?

1201

What is ADDM Advisor in Oracle?

1222

What is archive log in Oracle?

1182

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1162

How to create id with auto_increment on oracle?

1040

What is a user role in oracle?

1183

What are a query and state the different types of queries and their uses?

1064

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4231