SELECT * FROM SAMP; A -------- 1.1.3NN 1.1.4NN 1.5.1NN 1.3.2NE SEL

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 / ajit

2 Answers
4821 Views
I also Faced
E-Mail Answers

Answer Posted / ajit

SELECT * FROM SAMP;
A
--------
1.1.3NN
1.1.4NN
1.5.1NN
1.3.2NE

SELECT *
FROM SAMP
WHERE A LIKE '%NN';

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 the max number of columns in an oracle table?

1006

what is the difference between substr and instr function in oracle?

1099

How to calculate date and time differences in oracle?

1049

What is backup in Oracle?

1010

How to get execution statistics reports on query statements?

1108

Does oracle database need java?

1013

How to bring a tablespace online?

1087

What are the logical operations?

1131

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2120

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

2006

How many categories of data types in oracle?

1038

Why use resource manager in Oracle?

1113

How can I create database in oracle?

1036

How would you best determine why your MVIEW couldnt FAST REFRESH?

1898

What is an external table?

1033