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

Explain a segment?

1017

defination of bitmap index

2043

What are the uses of Database Trigger ?

1620

What happens if the imported table already exists?

970

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1666

Is primary key indexed by default in oracle?

928

What is sharded cluster?

924

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1321

What is a tns file?

937

How to add another datafile to a tablespace?

989

What is a dead lock in oracle?

1044

How to get a create statement for an existing table?

905

What is query image?

921

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1825

Can we call procedure inside function in oracle?

1015