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

Can you assign multiple query result rows to a variable?

973

How to create a table interactively?

1069

What is raw datatype in oracle?

1119

How do we create privileges in oracle?

1034

What is an oracle recycle bin?

987

What do you mean by group by clause?

1030

Explain the use of parfile option in exp command.

1056

What is a static data dictionary in oracle?

1090

Differentiate between function and procedure in oracle.

1054

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2093

What do you understand by a database object?

1044

What is the disadvantage of User defind function?

2270

how may join possible between (requisition with purchase order)

2235

Explain an integrity constrains?

1129

How to create a new table in your schema?

1072