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
4925 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 an oracle function?

1241

How to check the server version in oracle?

1140

How to delete all rows a table in oracle?

1119

What is a dynamic performance view in oracle?

1057

What is oracle join syntax?

1061

What are the oracle differences between nvl and coalesce

1233

What is instant client oracle?

1072

What are the parameters that we can pass through a stored procedure?

1117

State some uses of redo log files?

1064

How to load data from external tables to regular tables?

1102

How to generate query output in html format?

1209

What are the components of logical database structure in oracle database?

1135

What is literal?

1062

Explain the use of file option in exp command.

1174

Describe an oracle table?

1097