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
- 4813 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 |
What is the Tune Query
waht is referencial integrity?
How to export data to a csv file?
What do you mean by group by clause?
What language does oracle use?
How to add another datafile to a tablespace?
What is program global area (pga) in oracle?
what are the things that you consider while creating indexes on partitioning tables?
How to best split csv strings in oracle 9i?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
what is cartesian product?
How to convert raw data type into text in oracle? Explain
Oracle General 
