Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4707 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 |
How to Remove the 3rd highest salary person record from table?
State and explain the different types of data models?
difference between oracle8i and oracle9i
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
What are the advantages of oracle?
What is the difference between primary key and unique key and foreign key in oracle?
How to invoke the original export import utilities?
How do we represent comments in oracle?
12. Display the client name in upper case only and in lower case only.
How to return top 5 rows in oracle?
What is Oracle table?
How index is implemented in oracle database?
Oracle General 
