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
- 2 Answers
- 4311 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Can you have more than one content canvas view attached with a window ?
Is oracle a relational database?
What are various joins used while writing SUBQUERIES?
How can we force the database to use the user specified rollback segment?
What is an Extent ?
how can we store any pdf file in oracle
Is primary key = unique key,not null? If yes,please explain IF No,please explain
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
What is the recommended interval at which to run statspack snapshots, and why?
What is an oracle?
why pl sql doesn't support retrieving multiple records
Oracle General 
